Converting to dollar

[sathishkm]

Hi All,

I have and Revenue column to be converted in million. Is there any way to do so? Please find the attachment

[MarvinP]

Hi Sathishkm,

Divide by a million?? See the attached.

[sathishkm]

I need in this format
example $223.6M

Even for lower values it should express in million format

Example for 99000

Please find the attachment

[MarvinP]

Hi,
I thought that problem was too easy and you wanted more. See the attached where you need to do a Custom format with the numbers of 0.0"M" . Look at the Custom format.

For more fancy stuff read:
http://office.microsoft.com/en-us/ex...001216503.aspx