excel changes my decimal point

[mromandia]

Hi i have a recent problem with excel, when I enter a whole number with no decimal point, it automaticly moves the decimal point two spaces.
I have un-instaled and re-instaled excel in my mac, but it keeps doing it.

Example

if I enter 5, it shows .05
if i enter 100, it shows 1.00

but if i enter 12.5, it shows 12.5, so it only changes the numbers if i dont enter a decimal point.

Please Help.

 

[Andrew Poulsom]

Welcome to MrExcel.

In Advanced Excel Options uncheck 'Automatically insert a decimal point'.

 

[mromandia]

Andrew, where can i find advanced options.

 

[Andrew Poulsom]

In Excel 2003 there is a 'Fixed decimal' Checkbox under Tools|Options|Edit tab. In Excel 2007 Excel Options is on the Office Button dialog. In Excel 2010 Options is on the File tab.

 

[mromandia]

Thanks
i found it...