Forum Discussion
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:
4 Replies
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:
