Combining Date & Reference Number

[dcofer]

I have a date in Column A formatted as "mm-dd-yyyy" and a reference number in Column E. I want to combine the two in Column B, with the dashes retained between the month and date and between the date and year, plus preceed the date with the letter "D". When I use a formula such as ="D"&a2&e2, the date changes to a number.

For example, if I have 12-1-2008 in a2 and the reference number 71911320 in e2, when I use the above formula, I get D3978371911320 in b2. What I want is "D12-1-200871911320"

How can I combine the date in its same format followed by the reference number in column E and preceed it with the letter "D"? I would prefer a formula, but open to VBA if necessary.

Thanks for your help!

---dave

 

[Andrew Poulsom]

Like this?

="D"&TEXT(A2,"m-d-yyyy")&E2

 

[dcofer]

That worked perfectly.

Thanks!

--dave