View Single Post
  #2   Report Post  
Rob
 
Posts: n/a
Default

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.