Formula function

  • Thread starter Thread starter SDMFG
  • Start date Start date
S

SDMFG

Is there a function that will display the formula in a cell? For example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!
 
You could copy the formula from the Formula Bar so that the references don't
change,
then paste to another cell and just delete the = sign.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Is there a function that will display the formula in a cell? For example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!
 
Back
Top