How To Change Date Format In Excel To Dd/Mm/Yyyy

by

If you’re working with data in Microsoft Excel, you might come across a situation where you need to manipulate the date format. In most cases, Excel does a great job of recognizing different date formats. But sometimes, you might want to change the date format to a specific format such as DD/MM/YYYY. In this blog post, you’ll learn how to change the date format in Excel to DD/MM/YYYY.

Steps to Change Date Format in Excel to DD/MM/YYYY

  1. Select the cells that you want to change the date format.
  2. Right-click on the selected cells and choose Format Cells.
  3. Under the Number tab, choose Date from the category list.
  4. In the Type list, select the date format dd/mm/yyyy.
  5. Finally, click OK to save the changes.

Now, the date format in your selected Excel cells has been changed to DD/MM/YYYY.

Using Excel Formula to Change Date Format

You can also use an Excel formula to change the date format. Use the TEXT function to convert the dates. Here is the formula:

=TEXT(A1,"dd/mm/yyyy")

Replace A1 with the cell that contains the date you want to convert. This formula will return the date in DD/MM/YYYY format.

Conclusion

Changing the date format in Excel to DD/MM/YYYY is quick and easy, whether you do it manually or using a formula. Now you can display dates in the exact format that you need for your data analysis tasks.