Convert date to text
 

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.

Convert date to text
 

Hi,

Did you try this?

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

Mike

"Gene Augustin" wrote:

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.

Convert date to text
 

Try:

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

Regards,
Fred

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

Convert date to text
 

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.

Convert date to text
 

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Gene Augustin" wrote:

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.

Convert date to text
 

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

--
Rick (MVP - Excel)


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

Convert date to text
 

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



Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode