Date format change
Closed
Ane
-
Dec 21, 2015 at 11:58 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 25, 2015 at 12:05 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 25, 2015 at 12:05 PM
Related:
- Date format change
- Excel date format dd.mm.yyyy - Guide
- How to change whatsapp time format - Guide
- Format factory - Download - Other
- Change computer name cmd - Guide
- Facebook date of birth change - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 25, 2015 at 12:05 PM
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.
