Forum Discussion
How to convert from general to date format in this strange case?
Hello kind souls,
I am using Microsoft Excel 2013 and may i ask how do i
1) filter the day, month, and time from this format?
2) convert the general format to date format?
I have tried clicking the date format from the General dropbox but it doesn't work.
The link to this data is located here: http://bit.ly/2cgMGDm
Please Help! Thank you!
2 Replies
Hi Matt,
Put this formula in cell C2:
DATEVALUE(SUBSTITUTE(REPLACE(B2,1,SEARCH(",",B2),""),"-0000",""))Matt,
I tried to import the file with Power Query and it - almost - got it right. I only had to adjust the data type to "Date/Time/Timezone".
