Tools|options|Edit tab
uncheck that "fixed decimal places" box.

JohnO wrote:

When I type a number into a cell Excel displays the number divided by
1,000,000 unless the number is followed by a decimal point. What can I do to
change this?

--

Dave Peterson