Forum Discussion

Moses's avatar
Moses
Copper Contributor
Nov 29, 2018

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.

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 29, 2018

    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

Resources