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

Copy addition formula of non-consecutive horizontal cells 2
Descenders clipped 0
Style Gallery View 3
Formula Displays Instead of Result One Column Only 1
Tracked changes by multiple people modified to one 0
Excel - Wich Function should I use? 1
Word macro that can call cells out of Excel for a find and replace 0
Display weeks from a Milestone 0

Top