ExcelBanter - How do I stop excel from changing single numbers like 1 into a de.

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

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

- - How do I stop excel from changing single numbers like 1 into a de. (https://www.excelbanter.com/excel-discussion-misc-queries/3111-how-do-i-stop-excel-changing-single-numbers-like-1-into-de.html)

Jendayii

How do I stop excel from changing single numbers like 1 into a de.

Every time i enter a number like 1 or 2 excel changes it to 0.001, 0.002
etc... in order to display 1 i have to enter 100. How do i fix this?

JE McGimpsey

Tools/Options/Calculation. Uncheck the Fixed Decimals checkbox.

In article ,
"Jendayii" wrote:

Every time i enter a number like 1 or 2 excel changes it to 0.001, 0.002
etc... in order to display 1 i have to enter 100. How do i fix this?

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