Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|