I'm having problems with converting dates!
I have imported into Excel from a text file a date which is in an American format - this date however has been imported as a string format so Escel does not recognise it as a date. Then I need to convert that American Date into a british date.
I have about 400,000 dates to convert!!! So manual is definitely not an option!
Can anyone help please?
Eternally grateful if possible!!!