inserting a cell reference into a text field

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
 
R

RagDyer

="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!
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top