>I have tried to re-format in excel but with no luck. Why do the Americans have to have such a weird date system!!!!

For the same reason that all denominations of our paper money are of the same size and color. We are very ideosyncratic.