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