| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
| How di get excel to automatically change cell values | Excel Discussion (Misc queries) | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Hybrid Mode
