Covert date format in ms excel 2013 from MM-DD-YYYY to DD-MM-YYYY Posted on January 31, 2016 in Excel Change date format in ms excel 2013 form MM-DD-YYYY to DD-MM-YYYY =DATE(VALUE(RIGHT(A2,4)),VALUE(LEFT(A2,2)),VALUE(MID(A2,4,2))) where the MM-DD-YYYY string is in cell A2. You might also like...The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)Right side of a particular keyword in a string/text on ExcelFind a word between a string (sentence) using ExcelExcel Tutorial – Removing Stamp Time from Dates Previous Post: How do you stop and start the service in Central Aministration using PowerShell in SharePoint 2016? Next Post: Removing time element of Long Date Format using Excel Add Comment Cancel replyName (required) Email (required) Website (optional) Submit Comment