+ Reply to Thread
Results 1 to 3 of 3

When inserting a simple "Sum" formula all I get is the formula.

  1. #1
    Chris Bowling
    Guest

    When inserting a simple "Sum" formula all I get is the formula.

    I need to see the calculation and not the formula. I've used this process for
    years and have never had problems.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Talking

    goto tools=options=view and make sure formulas are not ticked off

  3. #3
    Bernard Liengme
    Guest

    Re: When inserting a simple "Sum" formula all I get is the formula.

    1) Make sure the cell is not formatted Text; if so, format it General then
    open the cell (F2 or double click) then Enter.
    2) Make sure you do not have View Formulas on: hold CTRL+` (the key to left
    of 1 on top row of so-called typewriter keys)
    If nothing works: enter some simple formula { =A1+A2 } somewhere and tell us
    what results
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Chris Bowling" <Chris [email protected]> wrote in message
    news:[email protected]...
    >I need to see the calculation and not the formula. I've used this process
    >for
    > years and have never had problems.




+ 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