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

T

txgp17

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.
 
T

Teodomiro

txgp17 said:
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.
Click to expand...

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