[b]Excel number format[/b] 1

[HacH]

Hi,

This may be a very basic question but it's really getting to me now as i've spent about 2hours trying to figure out what is wrong.

Usually when I type a number into my excel spreadsheet e.g. 1 or 2 or 550 etc it appears in exactly the same format. However i'm not sure what setting i've changed but now when i input any number it appears as a decimal e.g. 1 appears as 0.01 and so on. I have even reset the computer but I think the change has been made in normal.xls as it still has the same settings.

Please help!

Thanks very much in advance

HacH

 

[1726]

Turn Off Fixed Decimal Places option

Tools > Options

Edit tab