This post will guide you how to convert dd-mm-yyyy test string or a date to a standard date format mm/dd/yyyy with a formula in Excel.
Assuming that you have a list of data in range B1:B4 which contain text dates. And you need to convert these text dates to the standard date format mm/dd/yyyy. How to achieve it. You can use a formula based on the SUBSTITUTE function to achieve the result. Like this:
Type this formula into a blank cell and press Enter key in your keyboard, and then drag the AutoFill Handle over to other cells to apply this formula.