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 ...
Hi Matt,
Put this formula in cell C2:
DATEVALUE(SUBSTITUTE(REPLACE(B2,1,SEARCH(",",B2),""),"-0000",""))