How to Convert DD-MM-YYYY text string or date to a standard date format in Excel

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.

Convert Text DD-MM-YYYY to Date Format


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:

=SUBSTITUTE(B1,””-”,”/”)

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.

convert ddmmyyy test to date format1

Video: Convert DD-MM-YYYYY to Standard Date Format

Leave a Reply