see this url
http://groups.google.com/group/micro...wse_frm/thread
/8b9e14819e518a7a/2d2903c450a5094c?lnk=st&q=see+cell+value+not+formu la+in+fo
rmula+bar&rnum=1#2d2903c450a5094c
Rich wrote in message
...

copy all the lines and paste in the address bar of your browser

I think (I am not an expert) it is not possible to show in the formula bar
only the value and not the formula

but you can try this
create a command button onthe sheet
the code will be

Private Sub CommandButton1_Click()
MsgBox ActiveCell.Value
End Sub

then highlight any cell and click command button

you will get the message box with the value of the active cell

try and see whether it satisfies your purpose.


--
remove $$$ from email addresss to send email

=======================

I have a column where the cell contents are sometimes 200+ characters
long.
For me to see everything, I have to widen the column almost full-width of
my
screen, forcing all other columns off the screen, leaving me no choice but
to
scroll back and forth.

Normally, I could just select that cell and look in the Formula Bar to see
that cell's full contents. Unfortunately, this column uses a VLOOKUP
formula
to populate the cells so I cannot see what the values are; all I see are
the
formulas.

My worksheet already has split panes. In the top pane, I would like to
merge
several cells together and be able to see the full width of any cell I
select
*without* resizing that cell in the bottom pane. Can this be done?