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?

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

In article <[email protected]>,
"Jendayii" <[email protected]> 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?