[Ravi]

How to get the values in formula bar without affecting to the formula

[Harald Staff[_2_]]

Impossible, sorry. Formula bar shows formula.
If I understand the question that is...

Best wishes Harald

"Ravi" wrote in message
...
How to get the values in formula bar without affecting to the formula

[Gord Dibben]

Formula bar displays what is in the cell.

If a formula, it will show.


Gord Dibben MS Excel MVP

On Tue, 17 Jun 2008 05:50:01 -0700, Ravi wrote:

How to get the values in formula bar without affecting to the formula

[jaf]

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


"Ravi" wrote in message
...
How to get the values in formula bar without affecting to the formula