Step 1: Press the key combination Windows + S , enter Control Panel in the search box => click Open .
How to format dates in Excel quickly and easily Picture 1
Step 2: Click Clock and Region .
How to format dates in Excel quickly and easily Picture 2
Step 3: Click Region .
How to format dates in Excel quickly and easily Picture 3
- Select Country => date format as desired => OK .
How to format dates in Excel quickly and easily Picture 4
Step 1: Open the Excel file you want to format, highlight the date data area => right -click and select Format Cells .
How to format dates in Excel quickly and easily Picture 5
Step 2: Press Custom => time format options => OK .
How to format dates in Excel quickly and easily Picture 6
Step 3: After completing the result of changing the date format will be displayed as shown below.
How to format dates in Excel quickly and easily Picture 7
Step 1: Open the Excel file with date format, highlight the data area => right- click and click Format Cells .
How to format dates in Excel quickly and easily Picture 8
Step 2: Select Date => date and country format options => OK .
How to format dates in Excel quickly and easily Picture 9
Step 3: The results immediately change as below.
How to format dates in Excel quickly and easily Picture 10
Besides the above methods, users can also use shortcuts in Excel to easily format dates
- Ctrl + ";" : Enter the date, month, year in the box.
- Ctrl + Shift + ';' : Enter the time in the table.
- Ctrl + ';' combination of key press and key combination Ctrl + Shift + ';' : To enter date, month, year and time into Excel data table at the same time.
How to format dates in Excel quickly and easily Picture 11
In addition, Excel also allows users to use functions to format dates in Excel:
- TODAY function:
+ Formula: =TODAY()
+ Using the TODAY function will help you update the date, month, year, and year into the table data.
How to format dates in Excel quickly and easily Picture 12
- NOW function:
+ Formula: =NOW()
+ Unlike the TODAY function, using the NOW function will add more detailed hours and minutes.
How to format dates in Excel quickly and easily Picture 13
So TipsMake has just finished showing you how to format dates in Excel 2016, 2013, 2010, 2007, 2003. By formatting dates, it will help you calculate more accurately. For those who are new to using this tool, this is indeed a very necessary tip. In addition, the collection of 50 shortcut keys to use Ctrl in Excel that we send to you below is also one of the tips you must remember when using Excel.