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:
Printable View
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:
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