Forum Discussion
UK Date Format
Can someone please advise how to convert Text Date to UK format Date dd/MM/YY? I have attached a file where I am struggling to convert the date to UK format. My computer date is set to dd/MM/yyyy.
If your data is static you may Data->Text to Columns, select space as separator
on next step for the first column MDY format and copy to new destination (or keep at the same place)
remove extra columns after that.
Or by formula like
=(MID(B2,SEARCH("/",B2)+1,SEARCH("/",B2,SEARCH("/",B2)+1)-SEARCH("/",B2)-1) & "/" & LEFT(B2,SEARCH("/",B2)-1) & "/" & MID(B2,SEARCH("/",B2,SEARCH("/",B2,SEARCH("/",B2)+1))+1,4))+0