Remove slashes from date

  • Hi All,

    I get a data dump into an excel spreadsheet. In that spreadsheet I get a date in the format of mm/dd/yy. I need to get that date into another cell in mmddyy format. I was able to use a SumProduct formula to get a close result, but missing the leading zero for single digit months. I need the leading zero to be present. Formula approach or VBA, no preference for me. Hopefully this is clear and someone can assist. It would truly be appreciated. I have attached the worksheet with the data I am working with, as well as my SumProduct attempt. Thank you very much for taking a look.