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]



On Fri, 22 Jan 2010 07:09:01 -0800, Flipper
wrote:

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