|
input 7 in a cell in EXCEL 2000, it will automatically change to 8
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! |
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 |
| All times are GMT +1. The time now is 04:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com