been using excell to track orders. i recently upgraded from office 2000 to
2007.
all of a sudden when i type in a number like 250, it shows as 3 on the
spreadsheet.
i have checked that the settings is set as number and that there is no
formulas.

however if i start to type in as a formula like +250 + 0 it shows as 250.

i cannot find the fault.

Office button (Top left, large round button)Excel OptionsAdvanced tab, Uncheck Automatically insert a decimal point

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mopat" wrote in message ...
| been using excell to track orders. i recently upgraded from office 2000 to
| 2007.
| all of a sudden when i type in a number like 250, it shows as 3 on the
| spreadsheet.
| i have checked that the settings is set as number and that there is no
| formulas.
|
| however if i start to type in as a formula like +250 + 0 it shows as 250.
|
| i cannot find the fault.