I suppose I could create a custom function for this but I want to avoid this
if it can be done through Excel functions.

"Geoff" <gh@bob.com> wrote in message
news:OrXu7WeYFHA.4032@tk2msftngp13.phx.gbl...
> Without changing any of the options to reflect the formula in a worksheet,
> though an Excel worksheet function is it possible to return the formula in
> another cell.
>
> E.g.
>
> Cell A1=sum(a2:a200)
> The value returned and represented in the worksheet is say 2000
>
> I want to return the text "=sum(a2:a200)" through a formula and not VBA.
> Any ideas or suggestions?
>
> Thanks in advance
>