Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel no longer allows new formulas with 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel no longer allows new formulas with division "/" operator
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel file is no longer "in a recofnizable format" problem? | Excel Discussion (Misc queries) | |||
Is it possible to apply IF's to "operator" result.. | Excel Discussion (Misc queries) | |||
program stuck at "Save Cancelled by Operator" | Excel Discussion (Misc queries) |