Avatar of CompProbSolv
CompProbSolv
Flag for United States of America asked on

Excel 2003 oddity, works in Safe Mode

I am seeing an odd problem in Excel 2003 (on Windows XP) that I've not been able to resolve.

If you try to type the number 12 in any cell (by itself or in a formula), when you hit Enter, it changes to 14.  If you put in a formula that results in 12, such as =15-3, it works fine.  If you try =A12, it works fine.  If you type =100/12, it changes to =100/14.  I'm not seeing this with any other number.  I am not seeing any other oddities in Excel, but they could well exist.

It happens on a new worksheet as well with old ones.

It does NOT happen if Excel is opened in Safe Mode (pressing Ctrl) or if I log into Windows as a different user.

I have checked or changed to the following:
Tools, Add-Ins has everything unchecked
c:\D&S\username\Application Data\Microsoft\Excel\XLSTART is empty
Deleted (and it recreated) C:\D&S\username\Application Data\Microsoft\Excel\Excel11.xlb
c:\Program Files\Microsoft Office\OFFICE11\XLSTART is empty
HKCU\Software\Microsoft\Office\Excel\Addins only has (Default) (Value not set)
HKCU\Software\Microsoft\Office\11.0\Excel\Add-in Manager only has (Default) (Value not set)
HKCU\Software\Microsoft\Office\11.0\Excel\Options does not have an Open key

I'm trying to avoid recreating the user in Windows, but that may be the best solution.

Any suggestions on where else to look for the offending item would be appreciated.
Microsoft Applications

Avatar of undefined
Last Comment
CompProbSolv

8/22/2022 - Mon
SOLUTION
byundt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
mark_harris231

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mark_harris231

As an aside, if it is an auto-correct entry, it sounds like the work of a prankster.  This is standard MS Office prank material.  It might be worthwhile to inquire about anyone with recent access to the user's PC.
CompProbSolv

ASKER
Thank you all for your input.  I hope to have an opportunity to revisit this computer tomorrow and will post results if I do.
CompProbSolv

ASKER
Sometimes the problem is so obvious that I miss it!

mark_harris was right on the money.  I found the auto-correct entry, deleted it, and all is well.

The user has no clue as to how it occurred, but will be more watchful in the future.

Thanks!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
CompProbSolv

ASKER
While the answer from mark_harris correctly identified the problem, byundt gave an excellent answer about where else to look.