Thread: Format Date with other text in same forumula

I am trying to display both text and a date in the same line. Currently I have something like

="The Date Is " & A1

where A1 is a cell with a date formatted in a preferred format. However, once I call reference to the cell, excel re-formats it into the serial date, so it displays something like

The Date Is 40220

instead of something like

The Date is 2/11/2010

Does anyone know how to format the number back into a date form? Just going through the format menus and setting it to date does not change it. Thanks for your help

Try

="The Date Is " & TEXT(A1,"d/mm/yyyy")