You would have to create a UDF (user-defined function), with some code like
this:

Function GetFormula(Cell As Range) As String
GetFormula = Cell.Formula
If Cell.HasArray Then GetFormula = "{" & GetFormula & "}"
End Function

To create this function right click on a workbook tab, select view code, and
create a module in your workbook, then paste the above code in the module,
save, go back to your workbook and enter =getformula(A1) to return the
formula, if any, in A1.

Dave

--
Brevity is the soul of wit.


"Stranded" wrote:

I would like to be able to view a column of data alongside the formulas used
to calculate the data. I'm aware that all of the formulas can be displayed
via Tools/Options/Formulas and that Ctrl~ will toggle between the formulas
and values. The best I've come up with so far is to copy the formulas and
convert them to text cell by cell. At worst, is there a function to convert
the formulas to text as a group?

--
Richard