| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show the formula of another cell | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
