I have a function in my worksheet:
=CONCATENATE("[REPLY: INSPECTED ",V5,"; ",BP5,"]")
where cell V5 refers to a cell formatted as a date. The results of my formula are:
As you can see, Excel converts the date recorded in V5 to a serial number (in this case 39097 which is 1/15/07) when placing that the value of V5 into the concatenated string. How can I force the serial number to appear as a date in the string?