Try this UDF

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

In A1 enter 5*2 no = sign

In B1 enter =EvalCell(A1) returns 10


Gord Dibben MS Excel MVP

On Fri, 3 Apr 2009 08:13:01 -0700, Haydie-lady
wrote:

Is there a way to have a cell show the formula not the result? More
specifically show the formula with the values of the cells used to calculate
the result not the cell referenced. I want the cell next to my result(10) to
show the formula used to get my result, =5*2 OR =Height*Length NOT =B2*B3
EXAMPLE:

GIVEN
Height 5
Length 2
CALCULATED
Area 10