How can I change "Sep 1, 2018" to a usable date format in Excel?
View best response
Please try this trick:
Or use the DATEVALUE function:
Hope that helps
Thanks @Haytham Amairah
Text to columns:
This didn't do anything, should I be setting something on the 'Next' tab?
Returns #VALUE! error.
Any other suggestions? Thanks!
What exactly the date text looks like?
I think that there is NO space between the comma and the year as follows:
If so, go to the next step and uncheck all checkboxes there, then click Next to get to the third step, then choose the following option:
Thanks! This worked with the extra steps: