
You cells contain text, not Excel dates. The DATEVALUE formula can convert the data to a date value. Try =DATEVALUE(LEFT(your cell,FIND(" ",your cell)-1)). You will need to format the cell with this formula to a suitable date format.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm currently working with a several Excel sheets that have a column with mm/dd/yyyy hh:mm:ss MDT (time zone where it was created). Is there a way or formula to make the current column or a new column with just mm/dd/yyyy? I've tried selecting the column then selecting format & trying different date formats but nothing has happened at all to the data.
You cells contain text, not Excel dates. The DATEVALUE formula can convert the data to a date value. Try =DATEVALUE(LEFT(your cell,FIND(" ",your cell)-1)). You will need to format the cell with this formula to a suitable date format.