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.