Using the a date in A concatenate formula
 

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 ?

Using the a date in A concatenate formula
 

Hi,

Try this:

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

HTH
Jean-Guy

"HELP, Trying to more proficient here" wrote:

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 ?

Using the a date in A concatenate formula
 

one way
=CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,TEXT(I1,"mm/dd/yyyy"))
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"HELP, Trying to more proficient here" wrote:

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 ?

Using the a date in A concatenate formula
 

this was the answer that i was looking for thank you

"pinmaster" wrote:

Hi,

Try this:

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

HTH
Jean-Guy

"HELP, Trying to more proficient here" wrote:

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 ?