Try this ..

Click Tools Options Edit tab
Uncheck "Fixed decimal" OK

Things should be back to normal now ..

(it's a fixed decimal setting !)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Yonian" wrote in message
...
Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct.
What caused this and how can I fix it?