If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
When inserting a simple "Sum" formula all I get is the formula.
goto tools=options=view and make sure formulas are not ticked off -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=517335 |
#3
|
|||
|
|||
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 wrote in message ... I need to see the calculation and not the formula. I've used this process for years and have never had problems. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why wont this simple formula work | Bigredno8 | General Discussion | 3 | December 7th, 2005 03:22 AM |
Match then lookup | Tenacity | Worksheet Functions | 10 | December 3rd, 2005 05:30 AM |
Simple If-Then Formula | InsBrokerJayne | General Discussion | 7 | October 17th, 2005 10:29 PM |
Help with what should be a simple formula | B Millar via OfficeKB.com | Worksheet Functions | 2 | June 16th, 2005 04:18 PM |
Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |