Forum Discussion
Help with date format
What 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:
Hi,
Please try this trick:
Or use the DATEVALUE function:
=DATEVALUE(A1)
Hope that helps
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!
What 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:
Thanks! This worked with the extra steps:
- Select the relevant columns
- Choose Data → Text to Columns…
- Select “Delimited” and click Next
- Untick all delimiters and click Next
- Select data column format “Date: MDY” and click Finish