View Single Post
  #1   Report Post  
TreeHugger1 TreeHugger1 is offline
Junior Member
 
Posts: 12
Default Show a cell's formula in text format in a linked cell

I want to show the formula for a specific cell in text format in another cell.

For example, if cell A1 has a simple formula of "=10+64" (but only shows an answer of "74"), how can i link this cell to B1, so that B1 only shows as text "10+64" or " =10+64", instead of the actual answer?