formula displays as a formula, not as its result

Discussion in 'Microsoft Excel Worksheet Functions' started by dido22, Jan 25, 2012.

  1. dido22

    dido22 Guest

    Hi,

    I am using excel 2007.

    I have a simple formula in a cell , the cell displays the formula, not its
    result.

    I have checked under excel options/advanced/worksheet, the option 'show
    formulas ....' is un checked.

    Formats are set to 'general'

    Help please ?

    Thanks

    KK
     
    dido22, Jan 25, 2012
    #1
    1. Advertisements

  2. dido22

    GS Guest

    dido22 submitted this idea :
    > Hi,
    >
    > I am using excel 2007.
    >
    > I have a simple formula in a cell , the cell displays the formula, not its
    > result.
    >
    > I have checked under excel options/advanced/worksheet, the option 'show
    > formulas ....' is un checked.
    >
    > Formats are set to 'general'
    >
    > Help please ?
    >
    > Thanks
    >
    > KK


    Maybe...
    Did you change the cell format to "General" after you entered the
    formula? If so, select the cell, hit F2, hit Enter. The formula should
    now show a return value.

    --
    Garry

    Free usenet access at http://www.eternal-september.org
    ClassicVB Users Regroup! comp.lang.basic.visual.misc
     
    GS, Jan 25, 2012
    #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. Guest

    Formula window displays correct answer while cell displays incorre

    Guest, Nov 10, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    335
    Frank Kabel
    Nov 10, 2004
  2. Guest

    Formula displays result in formula box but not in cell

    Guest, Feb 8, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    217
    Guest
    Feb 8, 2006
  3. Guest

    Cell displays formula instead of the formula's result

    Guest, Jun 23, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    287
    Dave Peterson
    Jun 23, 2007
  4. DaveR

    Formula or function displays after edit and not its result

    DaveR, Jan 17, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    165
    Pete_UK
    Jan 17, 2008
  5. Reveal which formula causing true result

    Mult formula cell displays "0", which formula created result?

    Reveal which formula causing true result, May 24, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    177
    Rick Rothstein \(MVP - VB\)
    May 24, 2008
Loading...

Share This Page