Turns numbers into decimals.

  • Thread starter Thread starter Jem
  • Start date Start date
J

Jem

Halfway through my final project Excel started acting weird on me. I've
restarted and re-opened Excel but it's still doing the same thing.

If I type in a number ie: 1500000 it turns it into 15000
If I type in 1,500000 it keeps it proper and displays 1,500,000
Type in 123456789 it turns up as 1234567.89
 
Sounds like you have fixed decimals on. Click TOOLS/OPTIONS and the click
the EDIT tab. Turn of the checkbox FIXED DECIMALS.
 
Back
Top