ExcelBanter - Custon Number Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Custon Number Format (https://www.excelbanter.com/excel-discussion-misc-queries/254104-custon-number-format.html)

Flipper

Custon Number Format

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
--
Allan

Chip Pearson

Custon Number Format

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

Eduardo

Custon Number Format

Hi,
custom format , use

0.0,, "M"

"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
--
Allan

All times are GMT +1. The time now is 07:22 AM.