Convert date to text

[Gene Augustin]

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.

 

[Mike H]

Hi,

Did you try this?

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

Mike

 

[Fred Smith]

Try:

="D"&text(a1,"mm/dd/yy")

Regards,
Fred

 

[T. Valko]

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")

 

[Shane Devenshire]

Hi,

Well I think you've seen the solution. However, if you are ok with a
non-text solution then

Select the cells and choose Format, Cells, Number tab, Custom and enter the
following on the Type line.

"D"m/d/yyyy

 

[Rick Rothstein]

Here is a way to do it without the concatenation operation shown in the
first 3 responses (note the backslash in front of the D)...

=TEXT(A1,"\Dmm/dd/yy")

 

[Chris Bode]

Use following formula
="D" & TEXT(A1,"mm/dd/yy")



Chris