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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell reference in formula string displays abbreviated value 2
Date format 6
Use custom format to add text to a text entry. 4
2007 Pivot table Calculated field misbehaving 1
Rounding value from millions to decimal places 6
formatting cells 1
Custom number format problem 1
Count number of 2008 invoices for customers 2

Back
Top