If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel no longer allows new formulas containing the division "/" operator
I am using Excel 2002 and Windows XP Pro. Recently excel stopped
allowing me to enter formulas containing the "/" operator. So when I enter +3/4 or =3/4 I get an error. If I enter 3 in A1 and 4 in B1, then try to enter the =A1/B1 or +A1/B1 I get an error. If I open an existing spreadsheet that contains division formulas, they work fine, but if I try to enter a new formula in that spreadsheet I get the error "The formula you are trying to enter contains an error." for the new formula only. So obviously there is a problem with excel's recognition of "/". By the way all other operators "+", "-", "*", "^", etc, etc work just fine. This problem occurs only in my user profile in Windows XP, I can easily enter the same division formulas when I do so under another user's account in widnows XP. I tried "Detect and Error", removing and re-installing excel, removing 2002 and re-installing excel 2000, but I always have the same problem in my user account.(which I never had before until recently) Recently I was trying some demo programs of various accounting software and I wonder if one of them changed my settings or left a library behind that is causing this problem. Any ideas? Please reply to my email address: Thanks, akbaris |
#2
|
|||
|
|||
Excel no longer allows new formulas containing the division "/"operator
See some responses to your other post.
SA wrote: I am using Excel 2002 and Windows XP Pro. Recently excel stopped allowing me to enter formulas containing the "/" operator. So when I enter +3/4 or =3/4 I get an error. If I enter 3 in A1 and 4 in B1, then try to enter the =A1/B1 or +A1/B1 I get an error. If I open an existing spreadsheet that contains division formulas, they work fine, but if I try to enter a new formula in that spreadsheet I get the error "The formula you are trying to enter contains an error." for the new formula only. So obviously there is a problem with excel's recognition of "/". By the way all other operators "+", "-", "*", "^", etc, etc work just fine. This problem occurs only in my user profile in Windows XP, I can easily enter the same division formulas when I do so under another user's account in widnows XP. I tried "Detect and Error", removing and re-installing excel, removing 2002 and re-installing excel 2000, but I always have the same problem in my user account.(which I never had before until recently) Recently I was trying some demo programs of various accounting software and I wonder if one of them changed my settings or left a library behind that is causing this problem. Any ideas? Please reply to my email address: Thanks, akbaris -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|