Problem: Excel divides all my entries
 

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

Hi Sieto

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Sieto Verver" wrote in message
...
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

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

--
Andy.


"Sieto Verver" wrote in message
...
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

Thanks! That did the trick!
Exciting function....
"Sieto Verver" wrote in message
...
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