Custon Number Format

[Flipper]

I would like to format a cell so that the number, for example 135,000,000
would appear as 135.0M.

Is there a way to do this?

Thank you

 

[Chip Pearson]

Try

#,##0.0,,\M

Note the two commas after the second 0.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

 

[Eduardo]

Hi,
custom format , use

0.0,, "M"