Well one possibility is to create a UDF called get formula:

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

If there is a formula in cell A1, =getformula(A1) will show it.

But I'm not sure that this is what you're looking for. Another way to show
formulas is to put an apostrophe to the left of the = sign, but then the
formula itself doesn't calculate because XL considers that text.

Dave


--
Brevity is the soul of wit.


"Jim Carlton JMS" wrote:

Is it possible to show formulas on a worksheet in Excel x for mac? I know
how to do this on a pc, but I can not seem to find a way on this mac. I am a
teacher in middle school and I want to give a problem that the students can
solve and then print their answers in both values and formulas.

HELP!!

Jim Carlton