Feb 12 2018
07:44 PM
- last edited on
Jul 25 2018
11:02 AM
by
TechCommunityAP
Feb 12 2018
07:44 PM
- last edited on
Jul 25 2018
11:02 AM
by
TechCommunityAP
I need to be able to quickly sort and filter a very large file, but I can't since the dates are in a non-standard format. How can I quickly change the format to a '01-NOV-17' date? It would take hours to change the several thousands of line items one by one.
Feb 12 2018 07:52 PM
Feb 12 2018 08:59 PM - edited Feb 12 2018 09:01 PM
Meilani,
These dates are treated as texts so you have to convert them to real dates by using this formula:
=DATEVALUE(SUBSTITUTE(A1,".",":"))
This formula may give you the serial number of the date!
No problem, you can format these numbers to date format as follows:
Highlight them, press Ctrl+1, go to Date category, select the format that you prefer, and then hit OK.