ExcelBanter - entering 1.0 displayes as 0.1?

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

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

- - entering 1.0 displayes as 0.1? (https://www.excelbanter.com/excel-discussion-misc-queries/146757-entering-1-0-displayes-0-1-a.html)

Liglagsdad

entering 1.0 displayes as 0.1?

When I enter 1.0 it is displayed in the cell as 0.1. If I enter 123 it is
displayed as 1.23. I know it is something simple but just can't find the
answer

Chip Pearson

entering 1.0 displayes as 0.1?

Go to the Tools menu, choose Options, then the Edit tab, and uncheck the
"Fixed Decimals" setting.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

"Liglagsdad" wrote in message
...
When I enter 1.0 it is displayed in the cell as 0.1. If I enter 123 it is
displayed as 1.23. I know it is something simple but just can't find the
answer

Liglagsdad

entering 1.0 displayes as 0.1?

Thanks for the prompt reply. I new it was simple.

"Chip Pearson" wrote:

Go to the Tools menu, choose Options, then the Edit tab, and uncheck the
"Fixed Decimals" setting.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

"Liglagsdad" wrote in message
...
When I enter 1.0 it is displayed in the cell as 0.1. If I enter 123 it is
displayed as 1.23. I know it is something simple but just can't find the
answer

All times are GMT +1. The time now is 03:00 AM.