+ Reply to Thread
Results 1 to 4 of 4

How do I display the RESULT of a formula

  1. #1
    Poor microsoft user
    Guest

    How do I display the RESULT of a formula

    I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is
    "=1+1" (without the quotes). I go into microsoft help, do a search on
    "display formla", it has a section "display or hide formulas", it has "switch
    between displaying formulas and their values on a worksheet". I click that
    and it says:
    Press CTRL + (grave value)

    I have no idea what "grave value" means. I've already wasted an hour on this.

    HELP!!!!

  2. #2
    Guest

    Re: How do I display the RESULT of a formula

    Hi
    It may be that the cell was formatted as text before you entered the
    formula. Format it as General and re-enter the formula. The grave accent is
    ` which is to the left of 1 on my keyboard.

    --
    Andy.


    "Poor microsoft user" <Poor microsoft [email protected]> wrote
    in message news:[email protected]...
    >I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is
    > "=1+1" (without the quotes). I go into microsoft help, do a search on
    > "display formla", it has a section "display or hide formulas", it has
    > "switch
    > between displaying formulas and their values on a worksheet". I click
    > that
    > and it says:
    > Press CTRL + (grave value)
    >
    > I have no idea what "grave value" means. I've already wasted an hour on
    > this.
    >
    > HELP!!!!




  3. #3
    Poor microsoft user
    Guest

    Re: How do I display the RESULT of a formula

    Thank you Andy! I changed the formatting of the cell, it didn't help.
    However, after I changed the formatting of the cell, I RE-ENTERED the
    formula, and then it worked. I tried entering CNTL (grave symbol), it didn't
    help. I spent 45 minutes reading microsoft "help", and found nothing about
    the goofy way formatting cells as text before entering a formula will cause
    the formula to not function.

    Thanks again!

    "Andy B" wrote:

    > Hi
    > It may be that the cell was formatted as text before you entered the
    > formula. Format it as General and re-enter the formula. The grave accent is
    > ` which is to the left of 1 on my keyboard.
    >
    > --
    > Andy.
    >
    >
    > "Poor microsoft user" <Poor microsoft [email protected]> wrote
    > in message news:[email protected]...
    > >I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is
    > > "=1+1" (without the quotes). I go into microsoft help, do a search on
    > > "display formla", it has a section "display or hide formulas", it has
    > > "switch
    > > between displaying formulas and their values on a worksheet". I click
    > > that
    > > and it says:
    > > Press CTRL + (grave value)
    > >
    > > I have no idea what "grave value" means. I've already wasted an hour on
    > > this.
    > >
    > > HELP!!!!

    >
    >
    >


  4. #4
    Guest

    Re: How do I display the RESULT of a formula

    Thanks for the feedback! (I did put that you needed to re-enter the formula)

    --
    Andy.


    "Poor microsoft user" <Poor microsoft [email protected]> wrote
    in message news:[email protected]...
    > Thank you Andy! I changed the formatting of the cell, it didn't help.
    > However, after I changed the formatting of the cell, I RE-ENTERED the
    > formula, and then it worked. I tried entering CNTL (grave symbol), it
    > didn't
    > help. I spent 45 minutes reading microsoft "help", and found nothing
    > about
    > the goofy way formatting cells as text before entering a formula will
    > cause
    > the formula to not function.
    >
    > Thanks again!
    >
    > "Andy B" wrote:
    >
    >> Hi
    >> It may be that the cell was formatted as text before you entered the
    >> formula. Format it as General and re-enter the formula. The grave accent
    >> is
    >> ` which is to the left of 1 on my keyboard.
    >>
    >> --
    >> Andy.
    >>
    >>
    >> "Poor microsoft user" <Poor microsoft [email protected]>
    >> wrote
    >> in message news:[email protected]...
    >> >I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is
    >> > "=1+1" (without the quotes). I go into microsoft help, do a search on
    >> > "display formla", it has a section "display or hide formulas", it has
    >> > "switch
    >> > between displaying formulas and their values on a worksheet". I click
    >> > that
    >> > and it says:
    >> > Press CTRL + (grave value)
    >> >
    >> > I have no idea what "grave value" means. I've already wasted an hour
    >> > on
    >> > this.
    >> >
    >> > HELP!!!!

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1