Excel no longer allows formulas containing division "/" operator

Discussion in 'Microsoft Excel Crashes' started by SA, Nov 1, 2003.

  1. SA

    SA Guest

    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
     
    SA, Nov 1, 2003
    #1
    1. Advertisements

  2. Hi Sa,

    > Recently excel stopped
    > allowing me to enter formulas containing the "/" operator.
    >


    Look in Excel´s Tools, Options. There should be an International Tab.
    Check if there is an unexpected entry there (especially involving the
    division operator "/").

    Regards,

    Jan Karel Pieterse
    Excel MVP
     
    Jan Karel Pieterse, Nov 1, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Oniel McLeod

    Excel 2000 crashes opening file containing macros

    Oniel McLeod, Apr 1, 2004, in forum: Microsoft Excel Crashes
    Replies:
    7
    Views:
    673
    Guest
    Apr 2, 2004
  2. Guest
    Replies:
    2
    Views:
    687
    Rob Bovey
    Sep 27, 2004
  3. Jason Gallas

    excel 2000 freezes when opening a document containing a macro

    Jason Gallas, Mar 10, 2005, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    218
    Jason Gallas
    Mar 10, 2005
  4. Guest

    Cannot open Excel 2000 file containing PivotTables

    Guest, Feb 20, 2006, in forum: Microsoft Excel Crashes
    Replies:
    5
    Views:
    199
    Jan Karel Pieterse
    Feb 22, 2006
  5. Guest

    Automatic division of all input by 100

    Guest, Jul 9, 2007, in forum: Microsoft Excel Crashes
    Replies:
    2
    Views:
    243
    Guest
    Jul 9, 2007
Loading...

Share This Page