| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate a date and a # ID | Excel Worksheet Functions | |||
| Date concatenate? | Excel Worksheet Functions | |||
| Concatenate & Date | Excel Worksheet Functions | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Date CONCATENATE | Excel Worksheet Functions | |||
Linear Mode
