| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to combine dates stored in seperate columns
I have data that has the month and day together in one column ex. 125
and in the other is the year 2007 How do I get the date to be 12/5/2007? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to combine dates stored in seperate columns
How is it supposed to know it is 12/5/2007 instead of 1/25/2007?
-- ** John C ** "mrcosna" wrote: I have data that has the month and day together in one column ex. 125 and in the other is the year 2007 How do I get the date to be 12/5/2007? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to combine dates stored in seperate columns
well it is stored as text and the months that are not two digit have a zero
in front "John C" wrote: How is it supposed to know it is 12/5/2007 instead of 1/25/2007? -- ** John C ** "mrcosna" wrote: I have data that has the month and day together in one column ex. 125 and in the other is the year 2007 How do I get the date to be 12/5/2007? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to combine dates stored in seperate columns
Ok. Assume A1 has 125, and B1 has 2007
=DATE(B1,LEFT(A1,2),RIGHT(A1,LEN(A1)-2)) -- ** John C ** "mrcosna" wrote: well it is stored as text and the months that are not two digit have a zero in front "John C" wrote: How is it supposed to know it is 12/5/2007 instead of 1/25/2007? -- ** John C ** "mrcosna" wrote: I have data that has the month and day together in one column ex. 125 and in the other is the year 2007 How do I get the date to be 12/5/2007? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to combine dates stored in seperate columns
Thanks Alot John C "John C" wrote: Ok. Assume A1 has 125, and B1 has 2007 =DATE(B1,LEFT(A1,2),RIGHT(A1,LEN(A1)-2)) -- ** John C ** "mrcosna" wrote: well it is stored as text and the months that are not two digit have a zero in front "John C" wrote: How is it supposed to know it is 12/5/2007 instead of 1/25/2007? -- ** John C ** "mrcosna" wrote: I have data that has the month and day together in one column ex. 125 and in the other is the year 2007 How do I get the date to be 12/5/2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
| can i combine text from seperate cells into a sinle cell | Excel Discussion (Misc queries) | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| How do I sort dates stored as 1-Jun-05 in order of day & month | Excel Worksheet Functions | |||
Linear Mode
