Excel formats

Linda,

It may be a problem with the options settings if you have this problem with all new workbooks. If the problem only happens with one workbook the following may help.
Right click on a cell you are having this problem with. Choose "Format Cells..." and check the setting for that cell on the "Number" tab. Make sure it is "General" or "Number" with the decimal places set to 0.
If this solves the problem and you have only a few cells you need to correct you can select all the cells needing corrected one at a time by depressing the key as you click each cell then repeat the previous format change.
You can select the entire sheet and make the change, however, be careful as this setting will alter things such as dates. So I recommend you save a seperate copy like Test_YourWorkbookName.xls and make the changes there so you don't lose any information.

Hope this helps.
Krompton

Linda,

It may be a problem with the options settings if you have this problem with all new workbooks. If the problem only happens with one workbook the following may help.
Right click on a cell you are having this problem with. Choose "Format Cells..." and check the setting for that cell on the "Number" tab. Make sure it is "General" or "Number" with the decimal places set to 0.
If this solves the problem and you have only a few cells you need to correct you can select all the cells needing corrected one at a time by depressing the key as you click each cell then repeat the previous format change.
You can select the entire sheet and make the change, however, be careful as this setting will alter things such as dates. So I recommend you save a seperate copy like Test_YourWorkbookName.xls and make the changes there so you don't lose any information.

Hope this helps.
Krompton

Sorry I missed your comment stating this works with all workbooks. I should have included this in my previous answer but I thought it the more unlikely of the problems.

With Excel open. Click Tools-Options menu. On the "Edit" tab you will probably find the "Fixed Decimal" box checked. Un-check it and save the workbook. This should change the option for this and all new workbooks.

Good luck.

Check this area when you have formatting problems: Go to Tools menu, Options, Edit tab, uncheck "fixed decimal".
I had this unchecked and my general number category listed whole numbers. When I checked it and entered a number, it had two decimal places no matter what I did to change it.
Hope this helps.
Chris