ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel no longer allows new formulas with division "/" operator (https://www.excelbanter.com/excel-programming/281207-excel-no-longer-allows-new-formulas-division-operator.html)

SA

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

Hank Scorpio

Excel no longer allows new formulas with division "/" operator
 
On 31 Oct 2003 18:59:04 -0800, (SA) wrote:

Please don't post the same question to multiple groups. (Or if you
MUST, then cross-post a SINGLE message so that everyone can see follow
ups, and won't waste their time answering a question that may have
been answered elsewhere.)

This has nothing to do with Programming in any case. You've received
at least one reply in the microsoft.public.excel.misc group.

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.


[Snip]

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com