Using the a date in A concatenate formula

[Guest]

I am using the concatenate formula to join together various cells that have
different types of info. For some reason the cell with the date comes out as
a number when all the cells are put together.

This is my current formula: =CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,I1)
"I1" is the cell that has the date in it and it comes out looking like
this

7732 N NORMAL,CHGO, IL,60620,BRENDA WOODS,39398

I need it to look like this

7732 N NORMAL,CHGO, IL,60620,BRENDA WOODS,11/12/2007

How can i do this ?

 

[Guest]

Hi,

Try this:

=CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,TEXT(I1,"mm/dd/yyyy"))

HTH
Jean-Guy

 

[Guest]

one way
=CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,TEXT(I1,"mm/dd/yyyy"))

 

[Guest]

this was the answer that i was looking for thank you