Copy the formula to the cell below, and then:

Remove the equal sign,
OR
Add an apostrophe ( ' ) in front of the equal sign.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"srinivasan" wrote in message
...


"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