Problem: Excel divides all my entries

[Sieto Verver]

Hi All,
First my Excel 2003 was functioning perfectly, but now when I enter e.g. 1,
Excel automatically divides it by 10 and shows 0.1.
I'm aware that this is a cryptic descritpion, but it might be something
someone is familiar with.

Thanks!
Sieto

 

[JulieD]

Hi Sieto

try tools / options / edit and untick fixed decimal places if it is checked.

 

[Guest]

Hi
Have a look at Tools/Options/Edit tab and Fixed decimals.

 

[Sieto Verver]

Thanks! That did the trick!
Exciting function....