Hello

I have exported a data set to an excel file and i am trying to write a macros that will convert the data in the cell into a date format, and then use these dates to plot data points on a line graph. For example in my attachment, the first cell has data of 120304-000564. The part i need converted is the first half before the hyphen which is 120304. this should translate into 2012-03-04. The first two digits represents the year, followed by month and day. The second half of the numbers after the hyphen can just be removed.


once these numbers in column B are all converted into the proper date format, then i will need to activate a line graph creation from these data points. is this possible? thanks for any help!!