auto change number from 40 to 35

W

writingfaerie

This is a strange error that I have not been able to solve, nor has anyone
been able to help me figure it out. One of my employee's uses Excel 2003
daily, but he has gotten so annoyed with Excel that he threatens to beat the
computer into tiny pieces.

Here is his problem: When he opens Excel, either creates a new workbook OR
opens an existing file, and he types in the number 40 into a cell, Excel
automatically changes the 40 into a 35. Weird, right? We have found a
temporary solution to the problem. For now, he types in the 40, Excel changes
it to 35, and then he is running the Replace function and replacing all the
35's with 40's. We have not completely tested this theory, in that we have
not tried saving, closing, and re-opening the file to make sure the 40's
don't revert to 35's, but it seems like it will probably work.

I have over 50 computers in my hands, with all of them running Windows XP
and Microsoft Office. Most of them are on 2002 or 2003, with the exception of
myself who runs 2007. It seems very odd that his unit is the only one that is
having this error. We have even gone so far as to completely wipe his HDD
clean and re-install the programs, to no avail.

Please, can anyone help us out? I really would hate for him to blow up his
computer. He is our Maintenance Director and does have access to all kinds of
tools and chemicals he could use to demolish his unit.

Thanks so much for your help, anyone!
 
G

Gary''s Student

Sounds like the computer wants to go to a reduced workweek.

If the user enters 40.1 is it changed to 35.1 ?
 
J

Jan Karel Pieterse

Hi Writingfaerie,
Here is his problem: When he opens Excel, either creates a new workbook OR
opens an existing file, and he types in the number 40 into a cell, Excel
automatically changes the 40 into a 35. Weird, right? We have found a
temporary solution to the problem. For now, he types in the 40, Excel changes
it to 35, and then he is running the Replace function and replacing all the
35's with 40's. We have not completely tested this theory, in that we have
not tried saving, closing, and re-opening the file to make sure the 40's
don't revert to 35's, but it seems like it will probably work.

His problem is an entry in the autocorrect list (Tools, autocorrect options,
find 35 and remove it).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
W

writingfaerie

Yes, actually, when you type in 40.1 it does change automatically to 35.1. In
fact, as soon as you hit the decimal point, it changes the 40 to a 35.

Does anyone have any ideas on this? Please, I so could use the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top