Hi Angie,
See GetFormula in
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel/formula.htm

If not familiar with installing User Defined Functions and macros see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
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

"Angie" wrote in ...
How can I show currency and formulas in the same spreadsheet, at the moment I
can only show one or the other in Office XP Excel