How do I change this date (Nov 1, 2017 1:57:53 PM PDT) to 11/1/17?

Hi there. 

 

I’m challenged with this date information:  Nov 1, 2017 1:57:53 PM PDT (from Amazon data) and need to change it into a sortable date of 11/1/17.  I cannot sort A-Z with this format.  I have a huge list of these dates.  I need to change them and have no problem putting that information into another column for my spreadsheet.   I’ve been looking for a solution for several hours.  Hopefully there’s a one-step solution.  I’m tired of manually doing it.  I have too many cells to change.  It is not in a date format and changing the cell to a date format doesn’t do a thing.

 

Thanks in advance for your help.

 

date/timeNov 1, 2017 1:57:53 PM PDTNov 1, 2017 11:13:33 AM PDTNov 1, 2017 12:51:41 AM PDTNov 1, 2017 3:48:07 AM PDTNov 1, 2017 7:45:52 PM PDTNov 1, 2017 9:22:37 AM PDTNov 1, 2017 9:50:20 AM PDTNov 2, 2017 12:19:31 AM PDTNov 2, 2017 12:50:30 AM PDTNov 2, 2017 7:06:43 PM PDTNov 2, 2017 9:03:10 AM PDTNov 2, 2017 9:48:30 PM PDTNov 2, 2017 9:48:30 PM PDTOct 20, 2017 2:16:00 PM PDTOct 20, 2017 9:53:44 PM PDTOct 21, 2017 1:52:06 AM PDTOct 21, 2017 12:07:57 PM PDTOct 21, 2017 2:05:58 PM PDTOct 21, 2017 7:30:53 AM PDTOct 21, 2017 9:02:28 PM PDTOct 22, 2017 2:54:23 PM PDTOct 22, 2017 9:33:21 PM PDTOct 22, 2017 9:58:13 PM PDTOct 23, 2017 11:09:42 AM PDTOct 23, 2017 12:37:20 PM PDTOct 23, 2017 2:13:26 PM PDTOct 24, 2017 1:19:09 PM PDTOct 24, 2017 1:22:13 PM PDTOct 24, 2017 12:57:31 PM PDTOct 24, 2017 3:02:46 PM PDTOct 24, 2017 3:02:50 PM PDTOct 24, 2017 3:15:14 PM PDTOct 24, 2017 3:15:14 PM PDTOct 24, 2017 3:15:14 PM PDT

Alternate Text Gọi ngay