how do convert a cell with 8 numbers 19680422 into the date format 4/22/1968 ?
W womit Jul 2, 2008 #1 how do convert a cell with 8 numbers 19680422 into the date format 4/22/1968 ?
K Kevin B Jul 2, 2008 #2 Replace cell A1 in the expample with the corresponding cell in your worksheet: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
Replace cell A1 in the expample with the corresponding cell in your worksheet: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
P Pete_UK Jul 2, 2008 #3 Assuming they start in cell A1, put this in B1: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) Format the cell how you want it to appear, then copy down to B8. Hope this helps. Pete
Assuming they start in cell A1, put this in B1: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) Format the cell how you want it to appear, then copy down to B8. Hope this helps. Pete
D Dave Peterson Jul 2, 2008 #4 Another one: =--(TEXT(A1,"0000\/00\/00")) and format it as a date. If you have a single column of these things, you can: select the range data|text to columns (xl2003 menus) fixed width (no separators!) and choose ymd as the date format And then format it the way you like.
Another one: =--(TEXT(A1,"0000\/00\/00")) and format it as a date. If you have a single column of these things, you can: select the range data|text to columns (xl2003 menus) fixed width (no separators!) and choose ymd as the date format And then format it the way you like.
