Phew! I'm thought I was going crazy there for a moment.<g

Yes, you get the display the OP wanted... for that number. The original
intention of your format pattern was to round to 3 decimal places maximum
and to include the thousands separator... after Excel changes the pattern,
numbers will be rounded to 4 decimal places maximum and there will be no
thousands separator in numbers large enough to warrant them.

--
Rick (MVP - Excel)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I now see what you mean.

Enter in Custom .#,###,," MM" and OK

Excel changes to .####,," MM"

I just noticed that.

I never paid attention to what Excel did after I got the display in the
Sample dialog and hit OK

But the resultant display is .345 MM as OP wanted.

Sorry about not picking up the "missing comma" earlier.


Gord

On Mon, 9 Mar 2009 19:20:38 -0400, "Rick Rothstein"
wrote:

I don't get it... I cannot make your suggest format pattern work on my
system... it keeps throwing away the comma leaving four # characters after
the decimal point.