when I type "1", excel displays "0.1"

[browns87]

Hello,

Suddenly, whenever I type a number into excel (for instance "5"), excel then displays one tenth of that number (ie, "0.5"). I can temporarily get around this by typing "5.0" into excel, because it then displays "5". Whenever I paste a number, it displays the correct number as well. Any suggestions would be appreciated. Thanks in advance.

Related Information:
Mac OS 10.6
Excel 2008

 

[shg]

Excel Options > Advanced, under Editing options, untick Automatically insert a decimal point

 

[browns87]

You sir, are awesome. Your solution worked perfectly. Many thanks.