custom currency formating

[jenoh1]

Hi,
I think this is a really simple question but I am trying to forma
cells to show millions of dollars i.e. $6.5M
How do I add the 'M' from the custom formating option??

thanks for your help!
Jenn

 

[Guest]

Try this Custom format
$#,##0.00"M
Change the number of decimal places to suit your needs.

tj

 

[jenoh1]

thanks for the quick reply