Number Formatting in XL

Z

Zyvind

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?
 
Top