I have dates like 02/08/08 in column B
I want to convert them to a text like D02/08/08

Assuming that's mm/dd/yy format:

="D"&TEXT(B1,"mm/dd/yy")

--
Biff
Microsoft Excel MVP


"Gene Augustin" wrote in message
m...
I have dates like 02/08/08 in column B

I want to convert them to a text like D02/08/08
Everything I have tried gives an error or D38295 or the like where the
number part is the serial date.