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

"srinivasan" skrev i melding
...
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.