ExcelBanter - Autocorrecting my Number imput

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

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

- - Autocorrecting my Number imput (https://www.excelbanter.com/excel-discussion-misc-queries/135873-autocorrecting-my-number-imput.html)

GophsHcky5

Autocorrecting my Number imput

When I try to type 5 in a cell excel changes it to .05. How do I stop it
from correcting my numbers?

RagDyeR

Autocorrecting my Number imput

<Tools <Options <Edit tab,
And *Uncheck*
"Fixed Decimal".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"GophsHcky5" wrote in message
...
When I try to type 5 in a cell excel changes it to .05. How do I stop it
from correcting my numbers?

All times are GMT +1. The time now is 01:05 AM.