Doesn't matter if I'm working in an old spreadsheet or a brand new one.

When I type "1" I get a result of "0.00001" (shows as 0 to 0.0000 if I don't
have enough decimal places revealed).


When I type "100000" I get a result of "1".

If I type "1." (with the decimal) I get a result of "1".