View Single Post
  #1   Report Post  
Omunene
 
Posts: n/a
Default Copy formula so destination displays formula as text

Cell C123 contains the value 99.

I want cell A1 to display that value (99) and cell B1 to display the formula
(=C123).
I put =C123 in cell A1. What do I put in cell B1?

I know I can toggle between value and formula but how do I get them to both
display side-by-side at once?

THANK YOU!