Step 1:
You open the Excek document that needs to change the date format. As in my example, my date is entered in the format of month, day, and year.Step 2:
Next, we will Highlight the date format you want to change , click right mouse button and select Format Cells ...Appears Format Cells interface. In Number tab , you look down the item Category then select Date Look to the right view, item Location , you'll choose Vietnamese (Vietnam) to return to the Vietnamese input language. Soon after, part Type The above will also change the way Added in Vietnamese language . We click on the date type you want to use. Press to save new changes. Right there, the date format on the Excel data will change according to the format you chose, here is the date, month and year as shown below. So you can fix the formatting error in Excel, by changing the date formatting right on Excel's settings. In addition, to prevent this error should also let the date mode on the computer in the previous day and then month and year, or switch computer keyboard typing to Vietnamese to use.