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?
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?