Sounds like you have fixed decimals on. Click TOOLS/OPTIONS and the click
the EDIT tab. Turn of the checkbox FIXED DECIMALS.
--
Kevin Backmann


"Jem" wrote:

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