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.

Howdy and welcome to the board.

If you want to use another column to make it look like date, then use this formula for C1

=LEFT(B1,2)&"/"&MID(B1,3,2)&"/"&RIGHT(B1,2)

If you need it eventually in true date, then copy/paste special values.

Rich ~

Thanks for the info - it works perfect!
You da man!

Why not just use Data>Text to columns... and select MDY on the 3rd step?