Custom Number Format to abbreviate to Millions

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Would like to show in a chart:
Value is: 1,248,236
Would like shown as: 1.25M
or
Value is: 457,692
Would like shown as: 0.46M

This one escapes me.

TIA for any ideas.
Pierre
 
Pierre said:
Would like to show in a chart:
Value is: 1,248,236
Would like shown as: 1.25M
or
Value is: 457,692
Would like shown as: 0.46M

This one escapes me.

TIA for any ideas.
Pierre
Click to expand...


Try this:

#.00,,"M"
 
Hi,

You add custom number formats by choosing Format, Cells, Number tab, Custom
and entering the code in the Type box. Or in 2007 choose Home, Format, More
Number Formats, Number tab, Custom, ....
 
Back
Top