Excel  Numbers Formatting with Decimal Places
This document details a problem sometimes encountered with decimal places in Excel.
SYMPTOM
When entering numbers into excel they are being formatted with a decimal place. For example if you enter 1 it is getting formatted as .01.CAUSE
This behavior is caused by a setting contained in the Excel Options menu.SOLUTION
To fix the problem perform the following based on your version of Excel:Office 2007/2010/2013

Open Excel.

This step is dependent on the version of Excel you are using.
 Excel 2010/2013  Go to File > Options
 Excel 2007  Go to Office Button > Excel Options

Select Advanced in the left hand column.

Uncheck Automatically insert a decimal point.

Click OK
Office X/2001/XP/2003

Open Excel.

This step is dependent on the version of Excel you are using.
 Excel 2003  Go to Tools > Options
 Excel XP  Go to Tools > Options
 Excel 2001  Go to Edit > Preferences
 Excel X  Go to Excel > Preferences

Select the Edit tab.

Uncheck Fixed Decimal Places:.

Click OK.