My IT Manager has a spreadsheet that he imported some 40,000 dates into.
They are all formatted as text though, so we cannot simply change the cell format to receive the correct date. It takes the number, gives it a date format, but completely alters the date to something foreign. Can someone please show me how to convert this data via VB or some other way (leaving it in Excel) to reflect the right date. See attachment for what we are trying to accomplish on a larger scale. TIA.