Custom Number Format to abbreviate to Millions
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, ....
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Pierre" wrote:
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
|