SOLVED
Home

Help with date format

CRS80
New Contributor

Hi

 

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

 

Thanks!

4 Replies
Highlighted

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!

 

 

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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies