Using the a date in A concatenate formula

  • Thread starter HELP, Trying to more proficient here
  • Start date
H

HELP, Trying to more proficient here

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 ?
 
P

pinmaster

Hi,

Try this:

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

HTH
Jean-Guy
 
H

HELP, Trying to more proficient here

this was the answer that i was looking for thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top