Excel 97, strange rounding

  • Thread starter Thread starter Eric.Gambon
  • Start date Start date
E

Eric.Gambon

I am using state of the art excel 97 at work.

When I type in a number "4" it comes up as .04, when I put in "400" I
get 4.

First thing I thought was precentage, ok so I changed it to number
format with 2 decimal places and that resolved nothing. Nothing I do
to the cells changes this.

Ideas?
 
Someone has set your Excel up for quick money entry - you can type 12345 to
get 123.45 (one whole keystroke saved)
To undo this: Tools | Options | open the Edit tab | uncheck the Fixed
Decimal Places box
best wishes
 
Back
Top