SOLVED

Help with date format

Copper Contributor

Hi

 

How can I change "Sep 1, 2018" to a usable date format in Excel?

 

Thanks!

4 Replies

Hi,

 

Please try this trick:

Convert Text Dates to Real Dates.png

 

 

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!

 

 

best response confirmed by CRS80 (Copper Contributor)
Solution

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:

Convert Text Dates to Real Dates 2.png

 

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
1 best response

Accepted Solutions
best response confirmed by CRS80 (Copper Contributor)
Solution

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:

Convert Text Dates to Real Dates 2.png

 

View solution in original post