+ Reply to Thread
Results 1 to 3 of 3
  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
    Cochrane,Alberta
    MS-Off Ver
    XL 2003,2007
    Posts
    6,259

    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 Bowling@discussions.microsoft.com> wrote in message
    news:FA1545F5-A16F-482F-AE5C-C7BDDD247EC1@microsoft.com...
    >I need to see the calculation and not the formula. I've used this process
    >for
    > years and have never had problems.




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.2.0