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
|
|||
|
|||
need sum to show instead of formula in cell
I am trying to sum a column of numbers. Unfortunately the formula shows up
instead of the actual sum. Please help! |
#2
|
|||
|
|||
need sum to show instead of formula in cell
Check the formatting. It sounds like you have formatted it as text. If it
is, change it to number format, or general. You might have to edit the formul for the formatting to take effect (highlight the cell, hit F2, and then enter). "Linda" wrote: I am trying to sum a column of numbers. Unfortunately the formula shows up instead of the actual sum. Please help! |
#3
|
|||
|
|||
need sum to show instead of formula in cell
Select ToolsOptions and make sure that Formulas is unchecked in the Windows
Options section on the View tab "Linda" wrote: I am trying to sum a column of numbers. Unfortunately the formula shows up instead of the actual sum. Please help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Instead of a negative number, I'd like to show zero... | Dr. Darrell | Worksheet Functions | 6 | December 7th, 2005 08:21 PM |
Formula Problem - interrupted by #VALUE! in other cells!? | Ted | Worksheet Functions | 17 | November 25th, 2005 05:18 PM |
Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
How do I get a cell to show the data and not the formula? | Chris | General Discussion | 1 | November 7th, 2004 09:52 PM |
Do you have what it takes... | darno | Worksheet Functions | 0 | February 22nd, 2004 08:01 PM |