Converting `dd-mm-yyyy` to `dd/mm/yyyy` in Excel: 4 Methods Explained

how to conver dd-mm-yyyy to dd/mm/yyyy in excel ?

To convert a date in the format dd-mm-yyyy to dd/mm/yyyy in Excel, you can use the following steps:

Method 1: Using Text Functions

1. Assume your date is in cell A1:

   • If your date is in cell A1 and is stored as text, you can use the SUBSTITUTE function to replace the hyphens with slashes.

2. Enter the following formula in another cell:

   =SUBSTITUTE(A1, "-", "/")
   

This formula will replace all hyphens (-) with slashes (/).

Method 2: Using Custom Formatting

If the date is recognized as a date by Excel (i.e., it is not stored as text), you can change the date format using custom formatting.

1. Select the cells containing the dates.
2. Right-click and choose "Format Cells".
3. Go to the "Number" tab.
4. Select "Custom" from the list on the left.
5. In the "Type" field, enter dd/mm/yyyy.
6. Click "OK".

Method 3: Using Text to Columns

If the dates are stored as text and you want to convert them to actual date values:

1. Select the column with the dates.
2. Go to the "Data" tab on the Ribbon.
3. Click on "Text to Columns".
4. Choose "Delimited" and click "Next".
5. Uncheck all delimiters and click "Next".
6. In the "Column data format" section, choose "Date" and select DMY from the dropdown.
7. Click "Finish".

After this, you can format the cells to display the date in the dd/mm/yyyy format using the custom formatting method described above.

Method 4: Using a Formula to Convert Text to Date

If the date is stored as text and you want to convert it to an actual date value:

1. Assume your date is in cell A1:

   • Use the following formula to convert the text date to an actual date:

   =DATE(MID(A1, 7, 4), MID(A1, 4, 2), LEFT(A1, 2))
   

2. Format the resulting cell as dd/mm/yyyy using the custom formatting method described above.

By using any of these methods, you can convert dates from the dd-mm-yyyy format to the dd/mm/yyyy format in Excel.