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