View Single Post
  #1   Report Post  
excelhelp
 
Posts: n/a
Default How do I view formulas by values not by which cells they use to c.

Eg. formula is =B1 + C1
where B1 is 3 and C1 is 4
how can I get the cell to say
=3 +4

thanks