ExcelBanter - Wrong number displayed.

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

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

- - Wrong number displayed. (https://www.excelbanter.com/excel-discussion-misc-queries/154183-wrong-number-displayed.html)

Bob

Wrong number displayed.

Doesn't matter if I'm working in an old spreadsheet or a brand new one.

When I type "1" I get a result of "0.00001" (shows as 0 to 0.0000 if I don't
have enough decimal places revealed).

When I type "100000" I get a result of "1".

If I type "1." (with the decimal) I get a result of "1".

Peo Sjoblom

Wrong number displayed.

Toolsoptionsedit and deselect the fixed decimal places

--
Regards,

Peo Sjoblom

"Bob" wrote in message
...
Doesn't matter if I'm working in an old spreadsheet or a brand new one.

When I type "1" I get a result of "0.00001" (shows as 0 to 0.0000 if I
don't
have enough decimal places revealed).

When I type "100000" I get a result of "1".

If I type "1." (with the decimal) I get a result of "1".

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