| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get a value to appear in the cell and not the formula
When I enter a sum value for more than 30 cells in a column the formula
appears in the cell that I want the total to appear. Help me please |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i get a value to appear in the cell and not the formula
Format the cell as General
Hit F2, then the Enter key to reenter the formula. If that doesn't help, maybe you're looking at formulas. tools|options|view tab|uncheck formulas Tammy at NAIS wrote: When I enter a sum value for more than 30 cells in a column the formula appears in the cell that I want the total to appear. Help me please -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
