inserting a cell reference into a text field

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

I am trying to insert a refernce to a dymnamic cell into
a text field. In other words, my text field says "number
of days: AF5", where AF5 refers to the cell that contains
the number of days. How can i get the cell to recognise
the field refernce as data and not as text?
Thx
 
="Number of days : "&A5

Make sure the cell into which you enter this formula is formatted to
"General", *before* you enter the formula.
--

HTH,

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