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 |