Again-revealing the contents of formula
 

My Original post:
A cell contains the following calculation. =(28.36x38697/1000) and the answer
for this calculation is displayed in the cell. I want to know whether any
formula will display the numbers etc.,that has been used for the calculation
so that the one can have a the figures that have been used for the
calculation at a glance by placing the same in a cell beneath it.

Mr Harald's code for the same:
Function DisplayFormula(Cel As Range) As String
DisplayFormula = Cel(1).Formula

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

In Continuation of my query, I have another one. Even though the code
perfectly reproduces the formula contained in the cell it only shows the cell
reference of the formula. But I have given a name for the cell and the said
name is not displayed but the cell reference (row & col no) only has been
displayed. Is it possible to amend the formula /code to make it display the
exact contents of the formula (name given to the cell) rather than the cell
reference wherever the formula contains names. i.e instead of =L122*L119/1000
the formula should show -26.93*_36347/1000