At 15:58 15/04/2007 +0200, Johnny Andersson wrote:
I tried this:
0,###" mm"
I won't need more than 3 decimals.

This actually works, BUT if I enter an integer, say 3, the cell will show:
3, mm
I don't want that comma!

Any suggestions?

If you lose the "mm", then you can get what you need by using ,### as the format - without the leading zero. But adding the trailing text seems to resurrect the comma (well, point, in my case). Can you use this and move the "mm" into a separate column?

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to