From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Formatting numbers and dates
From the course: Excel 2016 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Exploring font styles and effects3m 17s
-
(Locked)
Adjusting row heights and column widths5m 40s
-
(Locked)
Working with alignment and Wrap Text6m 34s
-
(Locked)
Designing borders2m 55s
-
(Locked)
Exploring numeric and special formatting8m 1s
-
(Locked)
Formatting numbers and dates7m 18s
-
(Locked)
Using conditional formatting8m 13s
-
(Locked)
Creating and using tables11m 18s
-
(Locked)
Inserting shapes, arrows, and other visual features9m 35s
-
-
-
-
-
-
-
-
-
-
-
-
-