How to convert yyyy-mm-dd-to standard date in Excel?
If the worksheets you imported contain dates formatted as yyyy-mm-dd, how can you convert these dates to the standard date formatting mm/dd/yyyy for working? Here I introduce some tricks on solving this.
Quickly convert nonstandard date to standard date formattiing(mm/dd/yyyy)
|In some times, you may received a workhseets with multiple nonstandard dates, and to convert all of them to the standard date formatting as mm/dd/yyyy maybe troublesome for you. Here Kutools for Excel's Conver to Date can quickly convert these nonstandard dates to the standard date formatting with one click. Click for 60 days free trial!|
|Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.|
The following two formulas can convert the yyyy-mm-dd date format to the standard date format.
Select a cell which you will place the new date format, choose one of below formulas, then press Enter kety.
If there are dates with multiple formats you want to convert to standard date format, you can try to apply Convert to Date utility of Kutools for Excel.
|Kutools for Excel, with more than 120 handy functions, makes your jobs easier.|
After installing Kutools for Excel, please do as below:（Free Download Kutools for Excel Now!)
Select the dates you want to convert, click Kutools > Content > Convert to Date.
Then all selected dates have been converted to standard date format.
If you want to recover the conversion, you can select the dates in the Convert to Date dialog, click Recover.