I am using Excel 2003 with same problem. There is no Office button. How do
I get the entries not to be divided by ten?
Joe G

"Niek Otten" wrote:

Office button (large, round, top left corner)Excel OptionsAdvanced tab, uncheck Automatically insert a decimal point

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dipen" wrote in message ...
|I use excel 2007. Whenever i enter a number in cell, it gets divided by 100.
| For example, when i enter 10, it displays as 0.01.
|
| How to resolve this problem ? really frustrated with this error !
| DKL