Custom Number Format to abbreviate to Millions

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
 
G

Glenn

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"
 
S

Shane Devenshire

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, ....
 
Top