I have data in CSV format which contains dates (pasted below).
The dates of only some cells is recognized by Excel as date correctly (when I change Number type to Date).
How do I get the list of dates without having to manually type each out? Thanks.
The dates of only some cells is recognized by Excel as date correctly (when I change Number type to Date).
How do I get the list of dates without having to manually type each out? Thanks.
| 1/1/2010 23:58:00 |
| 1/4/2010 23:58:00 |
| 1/5/2010 23:58:00 |
| 1/6/2010 23:58:00 |
| 1/7/2010 23:58:00 |
| 1/8/2010 23:58:00 |
| 1/11/2010 23:58:00 |
| 1/12/2010 23:58:00 |
| 1/13/2010 23:58:00 |
| 1/14/2010 23:58:00 |
| 1/15/2010 23:58:00 |
| 1/18/2010 23:58:00 |
| 1/19/2010 23:58:00 |
| 1/20/2010 23:58:00 |
| 1/21/2010 23:58:00 |
| 1/22/2010 23:58:00 |
| 1/25/2010 23:58:00 |
| 1/26/2010 23:58:00 |
| 1/27/2010 23:58:00 |
| 1/28/2010 23:58:00 |
| 1/29/2010 23:58:00 |
| 2/1/2010 23:58:00 |
| 2/2/2010 23:58:00 |
| 2/3/2010 23:58:00 |
| 2/4/2010 23:58:00 |
| 2/5/2010 23:58:00 |
| 2/8/2010 23:58:00 |
| 2/9/2010 23:58:00 |
| 2/10/2010 23:58:00 |
| 2/11/2010 23:58:00 |
| 2/12/2010 23:58:00 |
| 2/15/2010 23:58:00 |
| 2/16/2010 23:58:00 |
| 2/17/2010 23:58:00 |
| 2/18/2010 23:58:00 |
| 2/19/2010 23:58:00 |
| 2/22/2010 23:58:00 |
| 2/23/2010 23:58:00 |
| 2/24/2010 23:58:00 |
| 2/25/2010 23:58:00 |
| 2/26/2010 23:58:00 |
| 3/1/2010 23:58:00 |
| 3/2/2010 23:58:00 |
| 3/3/2010 23:58:00 |
| 3/4/2010 23:58:00 |
| 3/5/2010 23:58:00 |
| 3/8/2010 23:58:00 |
| 3/9/2010 23:58:00 |
| 3/10/2010 23:58:00 |
| 3/11/2010 23:58:00 |
| 3/12/2010 23:58:00 |
| 3/15/2010 23:58:00 |
| 3/16/2010 23:58:00 |
| 3/17/2010 23:58:00 |
| 3/18/2010 23:58:00 |
| 3/19/2010 23:58:00 |
| 3/22/2010 23:58:00 |
| 3/23/2010 23:58:00 |
| 3/24/2010 23:58:00 |
| 3/25/2010 23:58:00 |
| 3/26/2010 23:58:00 |
| 3/29/2010 23:58:00 |
| 3/30/2010 23:58:00 |
| 3/31/2010 23:58:00 |
| 4/1/2010 23:58:00 |
| 4/2/2010 23:58:00 |
| 4/5/2010 23:58:00 |
| 4/6/2010 23:58:00 |
| 4/7/2010 23:58:00 |
| 4/8/2010 23:58:00 |
| 4/9/2010 23:58:00 |
| 4/12/2010 23:58:00 |
| 4/13/2010 23:58:00 |
| 4/14/2010 23:58:00 |
| 4/15/2010 23:58:00 |
| 4/16/2010 23:58:00 |
, someone may just stumble on this and solve his problem with the "Regional Settings" tweak
