ExcelBanter - Enter 1 in a cell, excel change to 0.001, WHY?

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

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

- - Enter 1 in a cell, excel change to 0.001, WHY? (https://www.excelbanter.com/excel-worksheet-functions/69388-enter-1-cell-excel-change-0-001-why.html)

Jag

Enter 1 in a cell, excel change to 0.001, WHY?

In the excel spread sheet.
when ever I enter any number it gets divided by 1000 on its own.
say if i enter 1 excel convert it to 0.001
i tried format cell option but could not correct it,
does any one know WHY?

Ron Coderre

Enter 1 in a cell, excel change to 0.001, WHY?

Try this:

ToolsOptionsEdit tab
Uncheck: Fixed Decimal Places.
(it's probably set for 3)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Jag" wrote:

In the excel spread sheet.
when ever I enter any number it gets divided by 1000 on its own.
say if i enter 1 excel convert it to 0.001
i tried format cell option but could not correct it,
does any one know WHY?

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