Excel Number Formatting

[Faruk Hosen]

1111849713678 (Actual value)
1,111,849.7 M (#,##0.0,, "M") Formated

Now need to show like this
11,118.50 C

Need format type

 

[Luke M]

If value was in cell A2, you could use this formula in a different cell.
=TEXT(A2*10,"#,##0.00,,, C")

That fact that you're shifting the commas by one place is why we multiply by 10.

 

[Chihiro]

Unfortunately, I don't think that's possible with number formatting alone. You'll need calculation done in another column/cell like Luke showed.

 

[Faruk Hosen]

Yea. Could it be possible through a macro?

 

[Faruk Hosen]

If value was in cell A2, you could use this formula in a different cell.
=TEXT(A2*10,"#,##0.00,,, C")

That fact that you're shifting the commas by one place is why we multiply by 10.

Thanks