I am using the following formula in a cell as follows:
="John was born on "&A1&" at New York City hospital."
The result I am getting is as follows:
John was born on 39346 at New York City hospital.
My question is, how do I modify my formula to convert to a date? I want the result to look as follows:
John was born on 09/06/1968 at New York City hospital.
Thanks in advance for any comments.
Bookmarks