Tools>Options>Edit tab, uncheck Fixed decimal
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|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 Options>Advanced tab, uncheck Automatically insert a decimal point
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |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
| >
| >
| >