Convert Date in Excel

[Sineadd]

Hi

I have data that has exported with the date in the below Format (General)

Jan 6, 2022

I have tried to change the format using Text to Columns but I cannot get the date to change to DD/MM/YYYY Format - A

Anyone able to help?

Using Excel 2019

Thanks
Sinead

 

[Fluff]

When using text to columns what did you select for the date format?

 

[Sineadd]

When using text to columns what did you select for the date format?

 

[Sineadd]

Hi I have included screen shots below of what appears

It doesnt show up correctly on last screen. Im sure its something simple but I just cant seem to figure it out

 

[Fluff]

You need to select the date format the data is in, not what you want. So in this instance you need to use MDY

 

[Sineadd]

You need to select the date format the data is in, not what you want. So in this instance you need to use MDY

When I do that it just splits the Month, Date and Year into seperate cells - Is it possible to get it to display as DD/MM/YYYY ?

 

[Fluff]

Uncheck all the boxes on the 2nd page

 

[Sineadd]

Uncheck all the boxes on the 2nd page

 

[Sineadd]

Tried that and nothing happens still stays in same format - below is format from excel sheet

Order Date Jan 6, 2022 Jan 23, 2022 Mar 15, 2022 Mar 27, 2022 Mar 31, 2022 Apr 5, 2022 Apr 7, 2022 Apr 11, 2022 Apr 11, 2022 Apr 11, 2022 Apr 15, 2022 Apr 17, 2022 Apr 20, 2022 May 2, 2022 May 2, 2022 May 6, 2022 May 7, 2022 May 7, 2022

 

[Sineadd]

Tried that and nothing happens still stays in same format - below is format from excel sheet

Order Date Jan 6, 2022 Jan 23, 2022 Mar 15, 2022 Mar 27, 2022 Mar 31, 2022 Apr 5, 2022 Apr 7, 2022 Apr 11, 2022 Apr 11, 2022 Apr 11, 2022 Apr 15, 2022 Apr 17, 2022 Apr 20, 2022 May 2, 2022 May 2, 2022 May 6, 2022 May 7, 2022 May 7, 2022

Apologies , It has worked now - not sure what I had done first time as went through same steps as advised

Thanks a mil for your help, i relaly appreciate it