Depending on the country you are in, you can use a few different date formats. In this lesson, I’ll show you how to convert any date format to dd/mm/yyyy (DMY). It’s the most popular format in the world used by more than half of the world’s population.
We are going to use this example.
The date is formatted to MDY (mm/dd/yyyy).
This is a format used only in the US and a few smaller countries.
Format Cells
The first way, you can convert the date is to use the Format Cells window. In order to do it, click cell B3, then click the right mouse button and select the Format Cells option.
From a new window, click Date and select the country where you are from.
If you can’t see your format, click the Custom category and type the one you want.
Text function
You can also use the text function to format your date to dd/mm/yyyy.
Let’s modify our example a bit.
Inside C3, insert the following formula.
1 |
=TEXT(B3,"dd/mm/yyyy") |
If you want to keep only the date inside C3, copy this cell and paste it as values. Otherwise, it’ll return an error.