How To Change Date Format in Excel

[Oh!Calcutta]

Dear All,

Can u help me format date column in dd/mm/yyyy style (I require this format) while the data is sent to me in other formats such as mm/dd/yy or mm/dd/yyyy?:confused:

[Howardc]

Hi,

Select columns dates are in and then select data>text to columns>fixed width under date select mdy and select finish. This will correct the dates so that they are formatted as dd/mm/yyyy


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)