currency & formulas

[Guest]

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

 

[David McRitchie]

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