See this:

http://tinyurl.com/y5tckh

Biff

"Oldersox" wrote in message
...
Is there a formula/function to display the formula/function in another
cell
as text.
eg if the formula in cell a1 is '=sheet1!A5' then in cell a8 i want to
display '=sheet1!A5' as text