Instructions on how to fix reverse dates in Excel

There are many cases when entering the date data into Excel will be reversed into the previous month, then to the day and year. Even if the user enters the correct order of date, the results still return months, days and years. This may be because you use an English-language version of Office, so when we enter dates it will all be in English-style. So how can I return to the correct date, month and year in Excel?

You can change the language of Windows to Vietnamese to fix the above error. At that time, when entering the date, Excel will automatically enter by date and year. If you want to limit this island's status, we can also reformat the column or date line in Excel.

Step 1:

You open the Excek document to change the date input format. As in the example, my date is entered in month, day and year format.

Instructions on how to fix reverse dates in Excel Picture 1

Step 2:

Next, we will highlight the area we want to change the date input format , right- click and choose Format Cells .

Instructions on how to fix reverse dates in Excel Picture 2

Step 3:

Appearance Format Cells interface. At the Number tab , look down at the Category section and select Date .

Looking at the interface on the right, Location , select Vietnamese (Vietnam) to return to Vietnamese language input. Soon, the Type section above will also change the way of typing in Vietnamese language . We click on the date type you want to use. Click OK to save the new changes.

Instructions on how to fix reverse dates in Excel Picture 3

Right there, the date format on Excel data will change according to the format you have chosen, here is the date, month and year as shown below.

Instructions on how to fix reverse dates in Excel Picture 4

So you can fix the month-to-month snooping format in Excel, by changing the date input format right above Excel's settings. In addition, to avoid this error, users should also leave the date mode on the computer in the style of the previous day and the month and year, or switch the computer keyboard percussion to Vietnamese to use.

Refer to the following articles:

1. Instructions on how to insert the current date in Excel

1. These are the most basic functions in Excel that you need to understand

1. 10 ways to recover corrupted Excel files

I wish you all success!