Custon Number Format

F

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
 
C

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]
 
Top