excel displays formula instead of value in one cell

A

auctionguy

As expected, some cells in my worksheet display the value of a formula in the
cell. Some will only display the formula. How do I change them to display
the value?
 
T

T. Valko

Select the cell in question
Change the cell format to General
Press function key F2
Hit 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

Excel VBA 1
Excel How to get output of the formula instead of True or false 1
DISPLAYING RESULTS OF A FORMULA 1
Pivot Value not formula 4
Pivot value not formula 1
Vlookup - value not formula 1
Cell displays Formula text 1
Vlookup - actual value not the formula 3

Top