Excel Problem

Sounds like you have Fixed Decimal P;aces set. Goto Tools>Options>Edit and uncheck the box Fixed decimal.
 
BTW, that was for Excel 2003 or prior. If you have Excel 2007 you will need to

Click the Office Button top left corner
Click Excel Options at the foot of that dialog
Select Advanced from the list
Under Editing options, uncheck 'Automatically insert a decimal point' check box

For Excel 2010, it is the same except there is no Office button, you click File in the top left.
 
Ken, they are just making it more and more discoverable!
 
Back
Top