Lisa MildonAuthor & editor

← All writing samples

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.

View archived image →

Download archived PDF →

Original publication ↗

← Back to the writing portfolio