View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teodomiro
 
Posts: n/a
Default 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