I'm having a nightmare.
The background is that I have an excel table containing audit data. The date row contains dates either in mm/dd/yyyy or mm-dd-yyyy.
I want them all to be dd/mm/yyyy (I am in the UK and the date is in US format). I've tried =Text(_,"dd/mm/yyyy) which converts the forward slash dates / fine, but nothing I do works on the hyphen - dates. Even substituting the - for a / creates errors.
Can anyone give me a formula that will convert it all in one go?
Thanks in advance :-)
Jemma
Bookmarks