Somehow you Excel is set to add decimals.
In XL2003 and earlier: Tools | Options | Edit and uncheck "Fixed Decimals"

In XL2007 Office | Excel Options| Advanced | editing options and uncheck
"Automatically insert decimal"
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dan" wrote in message
...
How do I restore the number format for excel? For example:
when I type in 45; cell automating displays .45. I have already tried
going
to formatcellgeneral etc; but each time I open another workbook same
thing
happens 45 becomes .45