Loading suggested videos

Step-by-Step Guide to Changing Excel Date Format

Change The Date Format In Excel

#spreadsheet date formatting

#date customization

#data presentation

#office productivity

“Quick tutorials, zero fluff. Learn it fast at gif.how.”

Steps to change the date format in Excel

Step 1: Select the range of cells that contain the dates you want to format.
Step 2: Press Ctrl + 1 to open the Format Cells window. Go to the Number tab, choose Date, select the format you prefer, and click OK.

Result: The selected dates will be displayed in the new format you chose.

Tip: Use Ctrl + Shift + # to quickly apply a default date format like dd-mmm-yy without opening the Format Cells dialog.

References

1https://www.youtube.com/watch?v=O_YtvIgsnoE

Is this video tutorial up to date?

Your feedback helps us improve our content.

Recommended Tutorials

No video found