Number entered in cell getting always divided by 100 !
ToolsOptionsEdit tab, uncheck Fixed decimal
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Gyro" wrote in message ...
|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
|
|
|
|