Forum Discussion
Convert To Date
Hi Excel Sheet GODS,
I am trying to convert below data to date in excel but i couldn't do it with (Datevalue & Text to columns), any other solutions from your side
| Thu, 2003-08-28 |
| Fri, 2006-07-28 |
| Sat, 2006-08-05 |
| Tue, 2008-07-01 |
| Sat, 2009-05-16 |
| Wed, 2003-01-01 |
| Mon, 2011-10-24 |
1 Reply
Text to Columns shall work if you assign proper format on 3rd step
Result is
(I use ISO date format)
