Help with date format

New Contributor



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



4 Replies



Please try this trick:

Convert Text Dates to Real Dates.png



Or use the DATEVALUE function:




Hope that helps

Thanks @Haytham Amairah 


Text to columns:

This didn't do anything, should I be setting something on the 'Next' tab?



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:

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