X
X
The Best Tech Newsletter Anywhere

Join 250,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

How to Use Periods in Dates in Excel

00_lead_image_changing_date_format

By default, short dates in Excel are formatted using slashes (3/14/2016). If you use a lot of dates in your worksheets, and you prefer to put periods in your dates (3.14.2016), you can easily change the format.

First, select the cells containing the dates you want to change. Then, right-click on the selected cells and select “Format Cells” from the popup menu.

01_selecting_format_cells

On the Format Cells dialog box, make sure the “Number” tab is active. Then, select “Custom” in the Category list box.

02_clicking_custom

Enter “m.d.yyyy” (without the quotes) in the “Type” edit box and click “OK”. To use a two-digit year in the dates, enter “m.d.yy”. Entering “mm.dd.yyyy” inserts a leading zero before single digit months and days and uses a four-digit date (01.04.2016).

03_entering_custom_type

The dates now use periods instead of slashes.

04_dates_with_periods

You can change the date format back to slashes or to any other date format, such as a long date or a date and time combination, using the same procedure. Just select “Date” in the Category list on the Format Cells dialog box and select a format in the “Type” list box.

Lori Kaufman Lori Kaufman
Lori Kaufman is a technology expert with 25 years of experience. She's been a senior technical writer, worked as a programmer, and has even run her own multi-location business.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read more than 1 billion times. Want to know more?

x

The Best Tech Newsletter Anywhere

Join 250,000 subscribers and get a daily digest of news, comics, trivia, reviews, and more.