Buzz
Learn how to adjust date and time formats in Excel using Short Date format.
- Step 1: Use your mouse to select the data range you want to format dates in Excel. Step 2: Right-click => select Format Cells. Step 3: Under Date category, choose the date format type under Type => select the country under Locale. Step 4: Preview the format type under Sample => click OK to save changes. Step 5: Check the displayed results.
Use keyboard shortcuts to format dates in Excel.
In addition to using menus on the toolbar, you can also format dates in Excel by using keyboard shortcuts to enter time or dates. Some key shortcut combinations you can use are:
Learn how to adjust date and time formats in Excel using functions.
If using keyboard shortcuts makes it difficult for you to operate, adjusting dates and times in Excel using functions will help you accomplish tasks more quickly and easily. Follow these steps:
- Step 1: Open the Excel spreadsheet.
- Step 2: Highlight the cells you want to remove date formatting from or select the entire data range for numeric entry.
- Step 3: In the Home tab, click the down arrow in the Number Format section => select the format type as Text.
- Step 4: Enter new numbers or delete the recently formatted numbers to check the results.
Here are simple ways to adjust dates in Excel, hopefully helping you gain more useful skills to swiftly tackle office tasks. There are plenty more valuable office skills shared by HR Insider in upcoming articles. Stay tuned!
