I type 1050 -Excel changes it to 1005
When I type the number 1050 in a spreadsheet cell and hit Enter, Excel
changes the number to 1005. This is the only number that changes this way. We try 1049, 1051, and any other number and Excel does not change them. When we type 1050*10 and hit Enter, we get the correct result. We also get the correct result when dividing 1050. This started to occur after updating the operating system from Windows 98 to Windows XP Pro. The Office suite is MS-Office 2000 Professional with all of the updates and the OS is Windows XP Pro with SP2 and updates. The computer has a Pentium 3.0GHz CPU. We checked the cell format settings and they are the same as those on an identical computer that was also upgraded to XP Pro. Any help is appreciated. |
I type 1050 -Excel changes it to 1005
"SolveIT" wrote in message
... When I type the number 1050 in a spreadsheet cell and hit Enter, Excel changes the number to 1005. This is the only number that changes this way. We try 1049, 1051, and any other number and Excel does not change them. When we type 1050*10 and hit Enter, we get the correct result. We also get the correct result when dividing 1050. This started to occur after updating the operating system from Windows 98 to Windows XP Pro. The Office suite is MS-Office 2000 Professional with all of the updates and the OS is Windows XP Pro with SP2 and updates. The computer has a Pentium 3.0GHz CPU. We checked the cell format settings and they are the same as those on an identical computer that was also upgraded to XP Pro. Any help is appreciated. Tools/ AutoCorrect Options Look for the offending line & delete it. -- David Biddulph |
I type 1050 -Excel changes it to 1005
Check your AutoCorrect settings.
TOOLS -- OPTIONS -- SPELLING Tab Click the "AutoCorrect Options" Button. Check to see if 1050 is on the replace list, if so delete it. HTH, Elkar "SolveIT" wrote: When I type the number 1050 in a spreadsheet cell and hit Enter, Excel changes the number to 1005. This is the only number that changes this way. We try 1049, 1051, and any other number and Excel does not change them. When we type 1050*10 and hit Enter, we get the correct result. We also get the correct result when dividing 1050. This started to occur after updating the operating system from Windows 98 to Windows XP Pro. The Office suite is MS-Office 2000 Professional with all of the updates and the OS is Windows XP Pro with SP2 and updates. The computer has a Pentium 3.0GHz CPU. We checked the cell format settings and they are the same as those on an identical computer that was also upgraded to XP Pro. Any help is appreciated. |
I type 1050 -Excel changes it to 1005
Thanks Elkar - you hit the nail on the head and now all is well!
"Elkar" wrote: Check your AutoCorrect settings. TOOLS -- OPTIONS -- SPELLING Tab Click the "AutoCorrect Options" Button. Check to see if 1050 is on the replace list, if so delete it. HTH, Elkar "SolveIT" wrote: When I type the number 1050 in a spreadsheet cell and hit Enter, Excel changes the number to 1005. This is the only number that changes this way. We try 1049, 1051, and any other number and Excel does not change them. When we type 1050*10 and hit Enter, we get the correct result. We also get the correct result when dividing 1050. This started to occur after updating the operating system from Windows 98 to Windows XP Pro. The Office suite is MS-Office 2000 Professional with all of the updates and the OS is Windows XP Pro with SP2 and updates. The computer has a Pentium 3.0GHz CPU. We checked the cell format settings and they are the same as those on an identical computer that was also upgraded to XP Pro. Any help is appreciated. |
I type 1050 -Excel changes it to 1005
Thanks David - I truly appreciate your help - Aidan
"David Biddulph" wrote: "SolveIT" wrote in message ... When I type the number 1050 in a spreadsheet cell and hit Enter, Excel changes the number to 1005. This is the only number that changes this way. We try 1049, 1051, and any other number and Excel does not change them. When we type 1050*10 and hit Enter, we get the correct result. We also get the correct result when dividing 1050. This started to occur after updating the operating system from Windows 98 to Windows XP Pro. The Office suite is MS-Office 2000 Professional with all of the updates and the OS is Windows XP Pro with SP2 and updates. The computer has a Pentium 3.0GHz CPU. We checked the cell format settings and they are the same as those on an identical computer that was also upgraded to XP Pro. Any help is appreciated. Tools/ AutoCorrect Options Look for the offending line & delete it. -- David Biddulph |
All times are GMT +1. The time now is 03:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com