ExcelBanter - How I keep the cells from becoming 1/100th of the value I enter?

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

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

- - How I keep the cells from becoming 1/100th of the value I enter? (https://www.excelbanter.com/excel-discussion-misc-queries/81912-how-i-keep-cells-becoming-1-100th-value-i-enter.html)

txgp17

How I keep the cells from becoming 1/100th of the value I enter?

When I enter "7" into a cell, it becomes "0.07" when I hit enter or go to a
different cell. I have the cell numbering set to the "general" category.

Teodomiro

How I keep the cells from becoming 1/100th of the value I enter?

txgp17 Wrote:
When I enter "7" into a cell, it becomes "0.07" when I hit enter or go
to a
different cell. I have the cell numbering set to the "general"
category.

Tools-Options, Edit tab, uncheck "Fixed Decimal", click OK.

--
Teodomiro

------------------------------------------------------------------------
Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140
View this thread: http://www.excelforum.com/showthread...hreadid=530635

All times are GMT +1. The time now is 06:56 PM.