From the course: Excel 2013 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 - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

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…

Contents