setting out date and months and years in excel -

i have set of data needs in date format looks 28041980 need in date format d/m/yyyy can done

this account leading day either 1 or 2 characters long. work assuming d/m/y

a1 = 28041980 a2 = 3091970     b1 =replace(replace(a1,len(a1)-3,0,"/"),len(a1)-5,0,"/")