how to see cell-data in formula bar ?
 

Good day
I have tried searching for an answer to this question but didnt find
anything relevant. Here it goes:
In MS Excel when I "drag down" a formula I want to see in the formula
bar Not the new formula for the respective new cell but the cell
contense (the actual data/text in the cell).

Its probably not a big deel but I cant find this Option anywhere ..

Thank you in advance !


--
theSefirah
------------------------------------------------------------------------
theSefirah's Profile: http://www.excelforum.com/member.php...o&userid=36951
View this thread: http://www.excelforum.com/showthread...hreadid=566603

how to see cell-data in formula bar ?
 

I am not sure what the real question is.

You will never see the data in the formula bar if you have a formula in a cell.

The formula results will be seen in the cells.

Seeing the formula and not the result indicates that the cell you typed it in
was formatted as text before you typed.

Select the cell and hit F2 then ENTER

OR.....on that sheet you have "View Formulas" enabled.

Hit CTRL + `(backquote above Tab key) to toggle off.


Gord Dibben MS Excel MVP



n Mon, 31 Jul 2006 08:55:26 -0400, theSefirah
wrote:


Good day
I have tried searching for an answer to this question but didnt find
anything relevant. Here it goes:
In MS Excel when I "drag down" a formula I want to see in the formula
bar Not the new formula for the respective new cell but the cell
contense (the actual data/text in the cell).

Its probably not a big deel but I cant find this Option anywhere ..

Thank you in advance !