View Single Post
 
Old 12-15-2010, 07:10 AM
thorgal67 thorgal67 is offline Windows XP Office 2003
Novice
 
Join Date: Apr 2009
Posts: 8
thorgal67 is on a distinguished road
Default Making Formulas Visible

I have a column (A) that contains a formula and displays the value

I would like to put in Column B a link to that formula, BUT there the formula should be displayed, and not the value.

Any ideas? Using "show formula" in Tools -> Options is not helpful, as I do not want to to display the formula in column A.

p.s. i use Excel 2003

Thanks
Reply With Quote