From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Formatting numbers and dates

Formatting numbers and dates

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Formatting numbers and dates

“

- In Excel, the standard display of dates is as we see them in Columns B and C, month, day, year in the United States, four-digit year, no leading zeros for the month or the day. If you type in an entry for example in cell G5 and simply typing 5/6, that would be May 6th, /16, 2016. But as I press enter, you see what happens. And for a lot of people in the United States, this is just fine, this is what they would want. If you want to save some space and you prefer a two-digit year, you can click the area that you're about to change, for example, Column B here, and immediately go to Format Cells, either by right clicking and choosing Format Cells, or pressing Control 1. And you'll see on Format Cell's dialog box, the Number tab, Date. And quite a few options in here. And you can even create your own customized versions if you wish. Here's the same kind of date but displayed with a two-digit year. And again, no leading zeros. If that's clear to you and if there's no confusion whatsoever…

Contents