"Rob" wrote:

Not sure about show in a cell beneath the formula, but if you please Ctrl
and the ` (key usually below Esc) this will show formula of all cells rather
than result of formula. To revert, press Ctrl and ` again.

HTH

"srinivasan" wrote in message
...
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.

No. This wont solve the problem. I want a formula that displays the exact contents of the cell figures to be displayed in a cell