Hi everybody!
When I have a number in a cell (like 1200000)and want to format it to look like 1.200.000. I go to format - number and click on the thousand seperator. What happens is that the number looks like 1200000.0.00 and the negative numbers look like -1.10/.10
Does anyone know how to change the number format so it looks normal? I've looke in the control panel- regional settings and the settings are all right there but still the numbers in excel look all wrong when I use the thousands separator.
Can anyone help.... I've been trying to fix this for days....with out luck.
Thanks a buch.... :wink:
When I have a number in a cell (like 1200000)and want to format it to look like 1.200.000. I go to format - number and click on the thousand seperator. What happens is that the number looks like 1200000.0.00 and the negative numbers look like -1.10/.10
Does anyone know how to change the number format so it looks normal? I've looke in the control panel- regional settings and the settings are all right there but still the numbers in excel look all wrong when I use the thousands separator.
Can anyone help.... I've been trying to fix this for days....with out luck.
Thanks a buch.... :wink: