View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kimmie40 Kimmie40 is offline
external usenet poster
 
Posts: 7
Default Getting the formula from a cell

On Apr 28, 9:31*am, Khai N <Khai
wrote:
I need the reference in the cell (i.e. need to extract the formula) instead
of the value itself so I can use it in another formula. How can this be done?


copy the original formula from the fx bar, not from the cell. Paste
the formula into the new cell.