Date format change

Closed
Ane - Dec 21, 2015 at 11:58 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Dec 25, 2015 at 12:05 PM
Hello,

The date format is as follows : Dec 15, 2015 10:47:52 AM, I need to change to the format "DD/MM/YYYY". Could you please help me with this.




1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Dec 25, 2015 at 12:05 PM
i am sure you are aware of using of formatting. So I am presuming that change of format is not making any difference. It would be due to that in excel dates are internally stored as number. So if you click on the date and then go to Data, text to columns, make sure Delimited is highlighted and press next. unselect all check box and choose date and select the format choose DMY format.
0