| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31
I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want
to convert these numbers into date format 2005/12/31, any suggestions, please... thanks in advance, cd |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31
=DATE(2000+LEFT(A1,1),MID(A1,2,2),RIGHT(A1,2))
Then... <Format <Cells "Custom" tab Enter: yyyy/mm/dd -- Regards, Dave "Curtis" wrote: I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want to convert these numbers into date format 2005/12/31, any suggestions, please... thanks in advance, cd |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I have a date 51231 (2005,dec,31) -I want to change to 2005/12
WOW,
I love this sight! You just made my dd, mm, yyyy! - thanks a ton. cd "David Billigmeier" wrote: =DATE(2000+LEFT(A1,1),MID(A1,2,2),RIGHT(A1,2)) Then... <Format <Cells "Custom" tab Enter: yyyy/mm/dd -- Regards, Dave "Curtis" wrote: I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want to convert these numbers into date format 2005/12/31, any suggestions, please... thanks in advance, cd |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I have a date 51231 (2005,dec,31) -I want to change to 2005/12
How about
=DATEVALUE("200"&TEXT(A1,"0-00-00")) and format as a date -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Curtis" wrote in message ... WOW, I love this sight! You just made my dd, mm, yyyy! - thanks a ton. cd "David Billigmeier" wrote: =DATE(2000+LEFT(A1,1),MID(A1,2,2),RIGHT(A1,2)) Then... <Format <Cells "Custom" tab Enter: yyyy/mm/dd -- Regards, Dave "Curtis" wrote: I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want to convert these numbers into date format 2005/12/31, any suggestions, please... thanks in advance, cd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date based on time | Excel Discussion (Misc queries) | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Linear Mode
