numbers rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Options>Advanced tab, Uncheck Automatically insert a decimal point

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
Back
Top