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.
Step 2:
Next, we will highlight the area we want to change the date input format , right- click and choose Format Cells .
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.
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.
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:
- Instructions on how to insert the current date in Excel
- These are the most basic functions in Excel that you need to understand
- 10 ways to recover corrupted Excel files
I wish you all success!
You should read it
- How to fix the SUM function doesn't add up in Excel
- Guidance on how to align Excel correctly
- Change the slash to a dot in Excel format
- How to arrange incremental dates in Excel
- Summary of expensive shortcuts in Microsoft Excel
- Instructions to stamp negative numbers in Excel
- How to display 0 in front of a number in Excel
- Tips for adding in Excel you need to know
May be interested
- Instructions for fixing errors with missing words when entering content in Wordmissing typing errors, or typing and losing words in word often happens, especially when we install vietnamese keyboards like unikey or vietkey. so how can we handle such situations?
- Instructions on how to change Inch to cm in Word 2007normally, we will use cm units to be familiar and easier to use. however, your version of word suddenly uses inch units, making it difficult to adjust alignment.
- 50 alternative slideshow applications for PowerPointmicrosoft powerpoint is famous for creating slide show presentations for presentations and ideas. however, if your computer is unable to install or cannot use powerpoint, you can use one of the powerpoint presentation applications to replace powerpoint in the following article of network administration.
- Fix 'Something went wrong' error on Office 2013microsoft office 2013 is one of the applications that supports opening, reading and editing text documents. however in some cases when opening the microsoft office 2013 application users face the error 'something went wrong' with the error message 'something went wrong. we're sorry, nhưng chúng không thể bắt đầu chương trình của bạn. hãy kiểm tra nó không bị tắt bởi hệ thống. error code: 1058-13 '.
- How to scroll bar scrolls horizontally and vertically in Word and Excelbecause of accidentally changing certain settings on word or excel, the scroll bar scrolls horizontally, vertical scrolling suddenly disappears. this sometimes makes it difficult for users to conduct text content processing, or excel data spreadsheets.
- How to insert the C degree icon in Word, Excel?how to insert c degree symbol into content word, excel, powerpoint? you have 4 ways to enter the c degree icon in word, excel and powerpoint, below are detailed instructions.