Let me be as specific as possible in what I am doing, because it's still not working.
Here is where I am getting my data from:
http://www.goldsheet.com/06cfblog.php
I am copying the Air Force data and pasting special as text to Excel. All the data gets put into column A. I am then trying to split it text to columns so that I can work with the data, but the Oct 21 12-19 score keeps coming up as Dec-19 no matter how I try formatting it beforehand. If I try to format it afterwrads some number comes up instead.