View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default numeric entries modified

Check Tools==Options=Edit==Fixed decimal places - latter should NOT be
ticked.

"dodhner" wrote:

In a particular column, numberic entries are automatically divided by 100.
At my last use of this spreadsheet, I didn't have this problem. I may have
inadvertantly pressed some keys which initiated this.