ExcelBanter - digit in a cell

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

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

- - digit in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/88255-digit-cell.html)

GYFong

digit in a cell

Each time I enter a numeric, like "1" or "2". The cell defaults to "0.001"
and "0.002" and so on. Until I type "100" returns "1". Please advise me how
to restore to true number exactly what I type? Thanks.
--
GY Fong

Toppers

digit in a cell

Tools==Options==Edit and deselect "Fixed Decimal places"

HTH

"GYFong" wrote:

Each time I enter a numeric, like "1" or "2". The cell defaults to "0.001"
and "0.002" and so on. Until I type "100" returns "1". Please advise me how
to restore to true number exactly what I type? Thanks.
--
GY Fong

GYFong

digit in a cell

Thank a lot!
--
GY Fong

"Toppers" wrote:

Tools==Options==Edit and deselect "Fixed Decimal places"

HTH

"GYFong" wrote:

Each time I enter a numeric, like "1" or "2". The cell defaults to "0.001"
and "0.002" and so on. Until I type "100" returns "1". Please advise me how
to restore to true number exactly what I type? Thanks.
--
GY Fong

All times are GMT +1. The time now is 08:33 AM.