Number Formatting in XL

[Guest]

I am normally using the "Comma"-format with 0, 1 or 2 decimals. However,
lately when I am trying to cut down from the default 2 decimals to 1 or 0,
the number is showing up with two commas, and a number of 0s added after the
last comma. One example;

10,00
becomes
10,0,000
when I try to reduce it to 10,0

Anyone with a cure for this disease?

 

[Frank Kabel]

Hi
what format have you applied exactly?

 

[pamela]

also check your format in date/time for windows.

pamela