ExcelBanter - Office Professional Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Office Professional Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/124182-office-professional-excel-2003-a.html)

Dave Scott

Office Professional Excel 2003

Cell format: recently my excel sheet cells will not format as instructed.
Inputing the number "3" is accepted as "0.03" when it should be "3" or "3.0".
Why is this occurring and how can it be fixed?

pinmaster

Office Professional Excel 2003

Hi Dave

Try Tools/Options/Edit and see if "Fixed decimal places" is checked, if it
is then unchecked.

HTH
Jean-Guy

"Dave Scott" wrote:

Cell format: recently my excel sheet cells will not format as instructed.
Inputing the number "3" is accepted as "0.03" when it should be "3" or "3.0".
Why is this occurring and how can it be fixed?

All times are GMT +1. The time now is 09:16 PM.