From the course: Excel 2013 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 - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Formatting numbers and dates
Excel gives you a variety of ways to display Date and Times. In this worksheet called Date and Time, look at the data in columns B and columns C, both showing essentially the same kind of data, simply displayed differently. The data in column B, shows four- digit-year and column C, two-digit-year. Obviously, one takes up more space. Sometimes that's the issue, usually not. Is it clear to the audience, whoever is using this? Recognize also the data in column I is different too. The formatting in column I, does clarify which month it is. Sometimes and particularly, if you're getting data from other countries, outside the United States, they tend to work with the layout of day, month, year, whereas in the U.S., we tend to use month, day, year. But if there's any doubt, column I tends to eliminate that by that display. Let's take a look at some of the built-in formats here. The standard display in most Excel versions is, as you type an entry, you see a four-digit-year, the way we're…
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
-
-
-
-
-
-
(Locked)
Exploring font styles and effects4m 7s
-
(Locked)
Adjusting row heights and column widths3m 37s
-
(Locked)
Working with alignment and Wrap Text4m 2s
-
(Locked)
Designing borders3m 26s
-
Exploring numeric and special formatting5m 36s
-
(Locked)
Formatting numbers and dates4m 31s
-
(Locked)
Conditional formatting4m 21s
-
(Locked)
Creating and using tables9m 59s
-
(Locked)
Inserting shapes, arrows, and other visual features6m 28s
-
(Locked)
-
-
-
-
-
-
-
-
-
-
-
-