Why does Excel show a formula in ONE cell ?

G

Guest

Excel is showing me a formula in just one cell on my spreadsheet, instead of
the formula result. I know the formula's correct (didn't forget to start
with "="). How do I turn off the formula and turn on the result? Other
adjacent cells are showing results rather than formulas. I can't find any
format switch that would do this, and nothing in HELP.
 
E

Earl Kiosterud

Ed,

The formula can show if the cell is formatted for text (Format - Cells -
Number tab). Make sure it's a format other than text. Then press F2 (edit)
then Enter.
 

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

return a formula instead of a value of a cell 4
Excel 2007 Not returning formula result 2
Formula showing in cell 4
how do i show the calculated value in a cell rather than formula 3
Cell formulas 2
Value won't show correctly in cell unless I double click formula, 1
Formula text in woorksheet cell 2
How to separate contents of one cell into multiple horizontal cell 1

Top