Forum Discussion
Solved
Help with date format
Hi How can I change "Sep 1, 2018" to a usable date format in Excel? 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 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