The intent is to show the formula actually in use in another cell, install
GetFormula in your personal.xls workbook
and invoke as follows:
=personal.xls!GetFormula(A1)

see page http://www.mvps.org/dmcritchie/excel/formula.htm

This will show the formula as you see it on the formula bar.

If the intent was to convert each address in a formula to a constant
and show it that way his is not the solution.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm