Text and dates into one cell without loosing date format
=A1 &" " & TEXT(B1,"dd/mm/yyyy")
A1=Text
B1=Date (in DD/MM/YYYY or other Date format)
HTH
"Hazeltine" wrote:
How can I put text and dates into one cell without loosing the date format.
I can use & and concatenate but the date format always gets lost.
|