Discussion Locked

speadsheet, 2 changes to 5

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

operating system is XP professional
software is office 98
program is speadsheet
When I type the digit 2 in the ones or tenth place in a number, the digit 2 is changed to a five. The way I enter the number 82 is typing "=82-3". The result is 85 shows up in the cell. This occurs when I open a new spreadsheet and immediately type the digit 2.
Has anyone seen this happen before?
Is there a way I could have set all new speadsheets to round, average or something?

4 replies

by mike_dee

hi. if it occurs ONLY when you type the number 2, I would suspect the problem to be with a macro or a function.

Search your system for Personal.xls and rename this to anything else so that it doesn't activate when you startup Excel.

If this doesn't work, my guess is that one of the template files (.xlt) is playing up.

Try creating a new template and use that as the default worksheet.

hope this helps.

by jbraten

the problem turned out to be auto correct,
it was set to change 82 to 85 and change .82 to .85

by kevin.square

you could also try starting Excel with the /a switch from Start - Run. A bit of a safe mode office startup. Will help you determine if there is a corrupt template or a bad add-on.

This discussion is closed to new replies.