Converting a number into a date within a text string.

[nsupanda]

I apologize if this has been asked before, I tried searching this forum for a solution but nothing seems to be exactly what I'm looking for.

I have the following text string ="PROJECTED BALANCE AT "&B19

Cell B19 contains the date that I want inserted into this text string. However, Excel is converting that date into a number when inserted into the text string formula. How do I convert it back to a date?

 

[Fluff]

Hi & welcome to MrExcel.
How about

="PROJECTED BALANCE AT "&TEXT(B19,"dd/mm/yyyy")

just change the format to suit

 

[nsupanda]

Hi & welcome to MrExcel.
How about

="PROJECTED BALANCE AT "&TEXT(B19,"dd/mm/yyyy")

just change the format to suit

Oh you are amazing, thank you so very much! I've been searching all over Google for this all morning long. So thankful I've found this forum.

 

[Fluff]

You're welcome & thanks for the feedback.