On Feb 17, 10:09*am, Glenn wrote:
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

Try this:

#.00,,"M"

Glenn, thank you too much!

Pierre