number to date format

[womit]

how do convert a cell with 8 numbers 19680422 into the date format 4/22/1968 ?

 

[Kevin B]

Replace cell A1 in the expample with the corresponding cell in your worksheet:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

 

[Pete_UK]

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

 

[Dave Peterson]

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.