Getting Values in Formula Bar

  • Thread starter Thread starter Ravi
  • Start date Start date
Impossible, sorry. Formula bar shows formula.
If I understand the question that is...

Best wishes Harald
 
Formula bar displays what is in the cell.

If a formula, it will show.


Gord Dibben MS Excel MVP
 
Hi Ravi,
Highlight part of the formula with the mouse or cursor keys and press F9 to
see the value.
If you hit the enter key the portion highlighted will be replaced by the
value.
To prevent this, hit the escape key to reset the formula.

John
 
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

Formula bar in Excel 2010 2
Excel Formula Bar Time Display Format 2
Display cell value 5
Formula Bar - display of content 4
Show value of cell in formula bar instead of formula 2
Missing Formula Bar 2
Cell contents in formula bar 9
Formula bar question 3

Back
Top