How to format dates in Excel quickly and easily
Instructions for setting date format in Excel 2019, 2016, 2013, 2010... in the article below, you can refer to it to shorten the time when entering date data used in Excel.
When entering a date value, you may encounter some cases where the displayed value is not the date value you entered but an integer. For example, you enter the date value 12/02/2012 but the value displayed on the spreadsheet is not 02/12/2012 but the number 40951. So what is this value of 40951?
Simple instructions for formatting dates in Excel
Step 1: Press the key combination Windows + S , enter Control Panel in the search box => click Open .
Step 2: Click Clock and Region .
Step 3: Click Region .
- Select Country => date format as desired => OK .
Step 1: Open the Excel file you want to format, highlight the date data area => right -click and select Format Cells .
Step 2: Press Custom => time format options => OK .
Step 3: After completing the result of changing the date format will be displayed as shown below.
Step 1: Open the Excel file with date format, highlight the data area => right- click and click Format Cells .
Step 2: Select Date => date and country format options => OK .
Step 3: The results immediately change as below.
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.
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.
- NOW function:
+ Formula: =NOW()
+ Unlike the TODAY function, using the NOW function will add more detailed hours and minutes.
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.
You should read it
- Top ladder aluminum armrest chair for quality family, cheap price
- Should buying aluminum ladders withdraw single or double?
- Buy aluminum chairs for families which is the best?
- Choose to buy safe, cheap aluminum ladders
- Which type of aluminum ladder should you buy best and most durable?
- Complete guide to Excel 2016 (Part 10): Use the Find and Replace function
- To know your biological age, check your urine sample
- Compare 3 premium aluminum ladder brands Nikawa, Nikita and Poongsan
- How to create a frequency chart in Excel
- Get started with Excel for beginners
- Tips for adding in Excel you need to know
- How to determine the type of account in Windows 10
Maybe you are interested
How to turn off Update Link notification in Excel - File content from many different sources Create Autotext in Word 2007, edit documents faster Alignment in Word 2010, beautiful alignment of Word 2010 documents How to master numerical data in Google Sheets with the AVERAGE function Excel 2016 - Lesson 8: How to format numbers in Excel (Number Formats) How to change commas to dots in Word - Number unit separator