#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 3 changes to 5


In both MS Excel 2003 when the 3 character is entered alone in a cell it
changes to a 5 character when the cursor moves to another cell. This happens
in all excel files on the computer.

(Note that this also happens in MS Word 2003 when entering a "stand-alone" 3
in text)

In other situations (Notepad, Netscape mail) this does not occur.

We use McAfee VirusScan 10 which is completeley up to date. Full scans have
been carried out in normal and safe mode as it was assumed this problem is
some sort of macro virus. McAfee finds no problem.

We have tested different keyboards.

When a 3 is entered as part of a larger number there is no problem.

There are no apparent macros running.

Any suggestions as to what to try next?

Many thanks

David

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default 3 changes to 5

Have a look at the auto correct options under toolsautocorrect to see if it
has been added there to change a 3 to a 5
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"David@Stellae" wrote:


In both MS Excel 2003 when the 3 character is entered alone in a cell it
changes to a 5 character when the cursor moves to another cell. This happens
in all excel files on the computer.

(Note that this also happens in MS Word 2003 when entering a "stand-alone" 3
in text)

In other situations (Notepad, Netscape mail) this does not occur.

We use McAfee VirusScan 10 which is completeley up to date. Full scans have
been carried out in normal and safe mode as it was assumed this problem is
some sort of macro virus. McAfee finds no problem.

We have tested different keyboards.

When a 3 is entered as part of a larger number there is no problem.

There are no apparent macros running.

Any suggestions as to what to try next?

Many thanks

David

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 3 changes to 5

In Excel, try Tools==AutoCorrect Options to see (though I can't think why
this should be done!!) that 5 is not set to replace 3.

The outcome you describe will happen if this is the case i.e single 3
becomes 5 but 12345 remains as entered.

If this solves the problem, look for same in WORD.

HTH

"David@Stellae" wrote:


In both MS Excel 2003 when the 3 character is entered alone in a cell it
changes to a 5 character when the cursor moves to another cell. This happens
in all excel files on the computer.

(Note that this also happens in MS Word 2003 when entering a "stand-alone" 3
in text)

In other situations (Notepad, Netscape mail) this does not occur.

We use McAfee VirusScan 10 which is completeley up to date. Full scans have
been carried out in normal and safe mode as it was assumed this problem is
some sort of macro virus. McAfee finds no problem.

We have tested different keyboards.

When a 3 is entered as part of a larger number there is no problem.

There are no apparent macros running.

Any suggestions as to what to try next?

Many thanks

David

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 3 changes to 5


Many thanks John (and Toppers), that was the problem. Need to remember to
cheque simple things before assuming it's something more complicated.

Of course the question of how the change 3 to 5 found it's way into the
autocorrect definitions is another matter!

Thanks again

David

"john" wrote:

Have a look at the auto correct options under toolsautocorrect to see if it
has been added there to change a 3 to a 5
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"David@Stellae" wrote:


In both MS Excel 2003 when the 3 character is entered alone in a cell it
changes to a 5 character when the cursor moves to another cell. This happens
in all excel files on the computer.

(Note that this also happens in MS Word 2003 when entering a "stand-alone" 3
in text)

In other situations (Notepad, Netscape mail) this does not occur.

We use McAfee VirusScan 10 which is completeley up to date. Full scans have
been carried out in normal and safe mode as it was assumed this problem is
some sort of macro virus. McAfee finds no problem.

We have tested different keyboards.

When a 3 is entered as part of a larger number there is no problem.

There are no apparent macros running.

Any suggestions as to what to try next?

Many thanks

David

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 3 changes to 5

Toppers

Info only...........

Excel and Word both use the same *.ACL so deleting from either App. deletes
from both.


Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 01:13:00 -0800, Toppers
wrote:

In Excel, try Tools==AutoCorrect Options to see (though I can't think why
this should be done!!) that 5 is not set to replace 3.

The outcome you describe will happen if this is the case i.e single 3
becomes 5 but 12345 remains as entered.

If this solves the problem, look for same in WORD.

HTH

"David@Stellae" wrote:


In both MS Excel 2003 when the 3 character is entered alone in a cell it
changes to a 5 character when the cursor moves to another cell. This happens
in all excel files on the computer.

(Note that this also happens in MS Word 2003 when entering a "stand-alone" 3
in text)

In other situations (Notepad, Netscape mail) this does not occur.

We use McAfee VirusScan 10 which is completeley up to date. Full scans have
been carried out in normal and safe mode as it was assumed this problem is
some sort of macro virus. McAfee finds no problem.

We have tested different keyboards.

When a 3 is entered as part of a larger number there is no problem.

There are no apparent macros running.

Any suggestions as to what to try next?

Many thanks

David


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"