How to fix date auto-jump error in Excel

How to fix date auto-jump error in Excel Picture 1

Due to the convention of the date format of different regions; For example, the Americas region is usually the month / day / year format; For some Asian countries and Vietnam usually use the day / month / year. Because of the difference, users sometimes encounter the error of writing the wrong date, the date you see jump is not according to your wishes even though the operation you enter does not matter.

For example, you are used to using the format of November 8, 2019 as November 8, 2019 but in Excel it displays as August 11, 2019 . Or you need to adjust the format in the order you are used to using the day / month / year.

How to fix date auto-jump error in Excel Picture 2

In this article, Dexterity Software will guide you how to fix date jump in Excel.

Edit how to enter dates in Excel

Normally the computer will default to the month / day / year input mode. That is, the computer will convention that the first number will be the month then the day and the year and be separated by a / sign. For example, when you enter November 8, 2019, the computer will understand that you are referring to August 11, 2019. To change the entry to suit the user's habits, you change the convention by adjusting the Region And Language Windows.

Step 1: Go to Control Panel by pressing Windows + R key combination on the keyboard. Run window appears, type Control Panel and press Enter on the keyboard or click the OK button on the Run window .

How to fix date auto-jump error in Excel Picture 3

Step 2: Control Panel window appears, depending on each version of Window the interface will be different as the content will be similar. You choose Clock, Language and Region .

How to fix date auto-jump error in Excel Picture 4

Step 3: Continue to select Region and Language .

How to fix date auto-jump error in Excel Picture 5

Step 4: In the Region and Language interface , Format section from English (UK) or English (US) format you choose to Vietnamese (Vietnam) to display correctly according to time format, digital symbols of Vietnam. Click the OK button .

How to fix date auto-jump error in Excel Picture 6

So then you can type time according to Vietnamese conventions and habits.

How to adjust the format for displaying the time of Excel

Although you have entered the data in the format of day / month / year; However, Excel automatically adjusts and displays the order in month / day / year.

How to fix date auto-jump error in Excel Picture 7

So, you can change the way of representing Excel's date format with the Number format tool by following these steps:

Step 1 : Select the data area to adjust the time format. For example, cell A3.

Step 2: Press Ctrl + 1 to open the Format Cells window . Click the Number tab (1) . Select Date (2) . On Locale (Locations) you move to Vietnamese (3) . In the Type window (4) will appear the date format according to the convention of Vietnam region. After selecting the format you need and then clicking the OK button (5) to apply the newly installed option.

How to fix date auto-jump error in Excel Picture 8

As a result, Excel switches to the time representation in the order of the day / month / year you desire.

How to fix date auto-jump error in Excel Picture 9

To adjust the date format according to the convention of the Americas (day / month / year), you follow the same way but choose the area (Location) is English (US). Good luck!

5 ★ | 2 Vote

May be interested

  • Top 5 best PDF file joining software and how to use itPhoto of Top 5 best PDF file joining software and how to use it
    if you have to work with pdf documents and documents, pairing pdf files will save you time and make it easier to manage. tipsmake.com provides readers with pdf file joining software to help us manipulate on pdf files more conveniently.
  • How to install Canon 2900 printer on Windows 10Photo of How to install Canon 2900 printer on Windows 10
    how to install the canon 2900 printer on windows 10. for office work, printers play an important role when you want to print documents. how to install the printer is not complicated, but not everyone knows. bi write this please
  • Beautiful and professional PowerPoint backgroundsPhoto of Beautiful and professional PowerPoint backgrounds
    beautiful and professional powerpoint backgrounds. in order for our powerpoint presentation to be impressive, the preparation and selection of background images to suit and fit the content to present is quite important. choosing a good background image and matching the context of the presentation will help your presentation attract attention
  • How to create and delete Watermark in Word 2016Photo of How to create and delete Watermark in Word 2016
    one of the copyright protection features in word 2016 we can mention is closing watermark. in this article, the software tips will guide you how to insert watermark and delete watermark in word 2016.
  • Summary of the most beautiful decorative bordersPhoto of Summary of the most beautiful decorative borders
    summary of the most beautiful decorative borders so that you can adorn your word page even more beautiful. tipsmake.com we synthesize contour files in word and png images for you to select and insert into your work.
  • How to zoom in and out of text in WordPhoto of How to zoom in and out of text in Word
    when we work in word, zooming in and out will often be used to quickly view the entire contents of pages in word. the way to zoom in and out of text in windows is also very diverse and there are many different ways.