I can't change the format to a number, different date or anything. This is a excel report was generated from Kronos payroll system. If there is a way to separate the date components by the "/" maybe I could do that and get it into an excel recognized format?
Select the column, click "Data" tab - click "Text To Columns" - select "Delimited" and click "Next", make sure "Other" is not checked and click "Next", select General and click "Finish"
There is a date option at the last stage if your date needs further adjustment rather than just the General option (only specifying General to start with as you sometimes have to use the reverse m/d to what you think depending on your region).