If you highlight the formula in the Formula bar and then press the F9 key,
the cell value will be displayed. Press the Escape key to exit.
Do not press enter.
--
Jim Cone
Portland, Oregon USA


"Tracy"
wrote in message
I have a column width which need to remain small.
The column contains an =function from another worksheet.
I need the cell to show the text information in the function bar at the top
of the sheet when highlighted, not the formula.
Or I need to insert a comment that allows me to insert a formula inside that
comment.
--
Tracy