="Text " & text(now(),"mm/dd/yyyy")

Replace now() with your date and mm/dd/yyyy with the formatting you desire

http://HelpExcel.com

"Tara Keane" wrote:

when I concatenate a text field & " "&date field it's displaying the text
fine but displaying the date in serial number
e.g. location and date 01/01/2001
becomes location and 19283
How can I maintain the date format?