Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The number 1 changes to 2 in any cell. OK if E.G. 10 or 21
This has just started. If I type the number 1 in any cell, it changes to a 2.
Also if I use -1 It is ok if I type, for example 21 or 10 or 111. Only if I use 1 by itself. Microsoft Office 2003 Pro Windows XP SP2. Run two virus checkers, no problems. Please help. Rodney Jackson |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
The number 1 changes to 2 in any cell. OK if E.G. 10 or 21
sounds like a macro
start Excel in safe mode (See help) and see if it still happens check <tools<options<general to see if there in anythin in the start up area "Rodney Jackson" wrote: This has just started. If I type the number 1 in any cell, it changes to a 2. Also if I use -1 It is ok if I type, for example 21 or 10 or 111. Only if I use 1 by itself. Microsoft Office 2003 Pro Windows XP SP2. Run two virus checkers, no problems. Please help. Rodney Jackson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
The number 1 changes to 2 in any cell. OK if E.G. 10 or 21
Have a look in Tools|Auto correct options
Put a 1 in the replace box and see if finds it. Mike "Rodney Jackson" wrote: This has just started. If I type the number 1 in any cell, it changes to a 2. Also if I use -1 It is ok if I type, for example 21 or 10 or 111. Only if I use 1 by itself. Microsoft Office 2003 Pro Windows XP SP2. Run two virus checkers, no problems. Please help. Rodney Jackson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
The number 1 changes to 2 in any cell. OK if E.G. 10 or 21
Hello Mike H and BJ,
The thing works normally in 'safe mode' but continues to fail in normal mode. I looked at <tools<options<general on both startup types, both appear the same. It looks like BJ is on the right track, although the problem persists. "bj" wrote: sounds like a macro start Excel in safe mode (See help) and see if it still happens check <tools<options<general to see if there in anythin in the start up area "Rodney Jackson" wrote: This has just started. If I type the number 1 in any cell, it changes to a 2. Also if I use -1 It is ok if I type, for example 21 or 10 or 111. Only if I use 1 by itself. Microsoft Office 2003 Pro Windows XP SP2. Run two virus checkers, no problems. Please help. Rodney Jackson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
The number 1 changes to 2 in any cell. OK if E.G. 10 or 21
while in safe mode try
Enable items that were disabled by Office Safe Mode On the Help menu, click About Microsoft <application. Click Disabled Items. Select the items you want to enable. Click Enable. you may be able to identify what is going on by when the problem starts happening as you enable items. "Rodney Jackson" wrote: Hello Mike H and BJ, The thing works normally in 'safe mode' but continues to fail in normal mode. I looked at <tools<options<general on both startup types, both appear the same. It looks like BJ is on the right track, although the problem persists. "bj" wrote: sounds like a macro start Excel in safe mode (See help) and see if it still happens check <tools<options<general to see if there in anythin in the start up area "Rodney Jackson" wrote: This has just started. If I type the number 1 in any cell, it changes to a 2. Also if I use -1 It is ok if I type, for example 21 or 10 or 111. Only if I use 1 by itself. Microsoft Office 2003 Pro Windows XP SP2. Run two virus checkers, no problems. Please help. Rodney Jackson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
The number 1 changes to 2 in any cell. OK if E.G. 10 or 21
Hello to 'bj' and also Mike H
first an apology to you both. I went to bed after my last post, today I re-read them while I was fully awake. The problem lay, as you indicated, in the <tools<options<general area. Last night I didn't scroll down far enough. Today I did and there was the problem...Replace 1 With 2. I have no idea where that came from as I have never been into the program settings before. Well now it is all correct. Sincere thank to you both for your time and expertise. I rate both your replies as 5 star or what ever the top rating is on this CZ. Rodney Jackson "bj" wrote: while in safe mode try Enable items that were disabled by Office Safe Mode On the Help menu, click About Microsoft <application. Click Disabled Items. Select the items you want to enable. Click Enable. you may be able to identify what is going on by when the problem starts happening as you enable items. "Rodney Jackson" wrote: Hello Mike H and BJ, The thing works normally in 'safe mode' but continues to fail in normal mode. I looked at <tools<options<general on both startup types, both appear the same. It looks like BJ is on the right track, although the problem persists. "bj" wrote: sounds like a macro start Excel in safe mode (See help) and see if it still happens check <tools<options<general to see if there in anythin in the start up area "Rodney Jackson" wrote: This has just started. If I type the number 1 in any cell, it changes to a 2. Also if I use -1 It is ok if I type, for example 21 or 10 or 111. Only if I use 1 by itself. Microsoft Office 2003 Pro Windows XP SP2. Run two virus checkers, no problems. Please help. Rodney Jackson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions |