custom currency formating

  • Thread starter Thread starter jenoh1
  • Start date Start date
J

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
 
Try this Custom format
$#,##0.00"M
Change the number of decimal places to suit your needs.

tj
 
Back
Top