When I type a number in a cell it comes up with two additional 00

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

Guest

When I type a number (i.e. 6) into a cell it comes up as 600. I've checked
the formatting and it is set to general. If I type 6.00 it comes up 6.00.
If I type 6. it comes up 600 again.

Is this a virus or something that changed in my settings. Please help. I
can't work with any new or existing spread sheets
 
Randy,

Sounds like Excel thinks it is displaying percent but without the %. Try
setting that cell to percentage with several decimal points, close, and then
reset the cell to General.

RayDiBug
 
Back
Top