Mar 01 2019 05:07 AM
Hi,
Please try this trick:
Or use the DATEVALUE function:
=DATEVALUE(A1)
Hope that helps
Mar 01 2019 05:18 AM
Thanks @Haytham Amairah
Text to columns:
This didn't do anything, should I be setting something on the 'Next' tab?
Datevalue:
Returns #VALUE! error.
Any other suggestions? Thanks!
Mar 01 2019 05:36 AM
SolutionWhat exactly the date text looks like?
I think that there is NO space between the comma and the year as follows:
Sep 1,2018
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:
Mar 01 2019 05:51 AM
Thanks! This worked with the extra steps:
Mar 01 2019 05:36 AM
SolutionWhat exactly the date text looks like?
I think that there is NO space between the comma and the year as follows:
Sep 1,2018
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: