how do i get a value to appear in the cell and not the formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
sumproduct - find text in string 11
custom data validation on cells with data validation values 2
value not recognized as a formula 1
Excel Typed text appears in wrong cell 0
Time Sum in Excel 1
How do I sum cells that have values from a text formula? 4
Formulas displayed in cell rather than calculated values? 4

Back
Top