View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
 
Posts: 109
Default input 7 in a cell in EXCEL 2000, it will automatically change to 8

nobattery wrote:
Hi, everyone,
When I input 7 in a cell in EXCEL 2000 and press enter, it will
automatically change to 8. Does anyone know what happened?
All other numbers are ok.
Only 7 is a problem.
77 is not a problem.
It seems there is a problem when I input 7 to 7.9, it will automatically
change to 8 to 8.9 accordingly.
e.g. input 7.1, it will change to 8.1
input 7.9, it will change to 8.9
Please anyone help!



Try Tools Autocorrect

Probably someone has modified it so that 7 converts (corrects) to 8

--
Message posted via http://www.officekb.com