ExcelBanter - cells

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cells (https://www.excelbanter.com/excel-worksheet-functions/139829-cells.html)

Mary

cells

When I put a number ex. (14) into a cell , then click to another cell
the number 14 changes to a .01. Any number I put in then click out of that
cell
the number will change to something different. This is in my excel
workbook.

JE McGimpsey

cells

Take a look at Tools/Options/Edit and check if the Fixed decimal places
checkbox is checked.

In article ,
Mary wrote:

When I put a number ex. (14) into a cell , then click to another cell
the number 14 changes to a .01. Any number I put in then click out of that
cell
the number will change to something different. This is in my excel
workbook.

All times are GMT +1. The time now is 02:52 AM.