"Harald Staff" wrote:

I think you would need a little VBA to do that.
Open the VB editor (Alt F11 or similar). Menu Insert Module. Paste this
into the module:

Function DisplayFormula(Cel As Range) As String
DisplayFormula = Cel(1).Formula
End Function

Return to Excel. With your calculation in cell A1, enter this in A2:
=DisplayFormula(A1)

HTH. Best wishes Harald

Thank you. I got it. it works fine.