How do I change Excel default number?

[PatrickR]

Recently upgrade to Excel 2007. When I type in 125000 and press enter key it
changes to 12.5 and when I type in 5000 it gives me 0.5 My question is how
do I change to setup so that what ever I typed in it stay that way? Thank
you for your help in advance.

 

[Niek Otten]

Office button (large round, top left)>Excel Options>Advanced tab>Uncheck
"Automatically insert a decimal point"

 

[PatrickR]

Wonderful, I learned something new today. Thank you very much Niek

 

[David Biddulph]

In Excel 2003 it is Tools/ Options/ Edit/ Fixed Decimal places
Converting 2003 to 2007, the equivalent of Tools/ Options is Office/ Excel
Options.

http://office.microsoft.com/en-us/excel/HP012164991033.aspx?pid=CH100870371033#3