vba - Excel Macro to format date -

i have column string value in excel file.

   col 20131022082702 20131022082702 20131022082739 20131022082739 

i want convert each cell value in date format e.g. yyyy/mm/dd hh:mm

20131022082702   // should formatted 2013/10/22 08:27  

i wondering if there built in function can use format using kind of macro?

one approach can think of taking sub string , writing custom logic in macro. other work around appreciated !

thank time.

if use text worksheet function, can format date/time stamp, , excel convert "real" value. can format wish:

=--text(a1,"0000\/00\/00 00\:00\:00") 

edit: in vba, 1 can use line conversion. similar algorithm, using native vba functions:

cdate(format(n,"0000 00 00 00:00:00")) 

where n 14 digit number