2000 becomes 20 in XP

[MrPeder]

I have I problem with my Excel XP. When I type 2000 the cell value is shown as 20.
Of course I have reintsalled Excel but same **** after a while.
Anyone who can help?
Peder Skogaas, Norway

 

[XL-Dennis]

Peder,

See if the following can be of help for You:

1. Open Excel
2. Choose the command Tools | Options
3. Choose the tab Edit
4. Uncheck the Fixed Decimals.

 

[MrPeder]

Thanks Dennis

Thank you Dennis. It works!.

 

[XL-Dennis]

You're welcome