Try it this way:

="Start Date: "&TEXT(A2,"mm/dd/yyyy")

Hope this helps.

Pete

On Dec 5, 8:39 pm, Jeff Stouse
wrote:
Hi all,

If I have a serial number (such as 39401) representing a date, and
formatting a date) which displays 11/15/2007 in A2, and I want to join that
with text in a cell A3 using the following formula:

="Start Date: "&A2

The result is:

Start date: 39401

Not:

Start date: 11/15/2007

So I understand that Excel loses the formatting of the number in the cell as
soon as I use the & to concantenate text to it, but I can't find a function
that will turn the value (39401) into a date when used in a formula...

Any ideas?

TIA,
Jeff