I've seen loads of posts about this but none that answered this problem.
We import data from an XML file, and the input date is (for example) 12MAR2013. Excel has no problem with this and correctly imports it fine, however the date display is "12-Mar-13". Now I know we can change how its shown...