Technology
How to Format Dates in Excel
Lifewire · 2019-08-14

About this piece.
• Under the Cells group, select the Format drop-down, then select Format Cells. • Under the Number tab in the Format Cells dialog, select Custom. Just like the Date category, there are several formatting options. • Once you’ve settled on a format, select OK to change the date format for the selected cell in your Excel spreadsheet.
How to Format Cells Using a Mouse
If you prefer only using your mouse and want to avoid maneuvering through multiple menus, you can change the date format with the
Saved copies.
These archived files are hosted on this website. Dates, prices, and offers reflect the original publication.
