View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default 1 becomes 10, how can I stop this


HerbalDave wrote:
Iv'e been working with basic formulas and worksheets for a short time. Today
I opened a saved sheet and found that when I use a number and enter to the
next cell, the number gains a zero ie 1 becomes 10. If anyone can help out
with this I'd be very grateful.

Many thanks

DB


Hi HerbalDave

If custom formats aren't the probelm, check to see if a macro is
changing the cell.

Regards

Steve