View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SolveIT
 
Posts: n/a
Default 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.