How to get the values in formula bar without affecting to the formula
H Harald Staff Jun 17, 2008 #2 Impossible, sorry. Formula bar shows formula. If I understand the question that is... Best wishes Harald
Impossible, sorry. Formula bar shows formula. If I understand the question that is... Best wishes Harald
G Gord Dibben Jun 17, 2008 #3 Formula bar displays what is in the cell. If a formula, it will show. Gord Dibben MS Excel MVP
J jaf Jun 19, 2008 #4 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
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
