Date format change
Closed
Ane
-
21 Dec 2015 à 23:58
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 Dec 2015 à 12:05
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 Dec 2015 à 12:05
Related:
- Date format change
- How to change date format in excel - Guide
- Kingston format utility - Download - Storage
- Hdd low level format tool - Download - Storage
- Format factory for pc - Download - Other
- Change lg tv name - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
25 Dec 2015 à 12:05
25 Dec 2015 à 12:05
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.
