From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

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

Set special formats for dates, times, phone numbers, and zip codes

Set special formats for dates, times, phone numbers, and zip codes

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Set special formats for dates, times, phone numbers, and zip codes

“

- We're on a worksheet called SpecialFormats. Excel has a number of built-in formats, and also the capability of creating your own. In this worksheet over in column A, we've got some Date entries, nothing wrong with that. If you'd like to see a four digit year, one quick way is, on the Home tab, go to the Number group, click the drop arrow here, above. How about Short Date? We get that display. Or, you saw the other one, perhaps, Long Date. Column is going to have to be a lot wider for that one. There are all kinds of variations on what you might use here for dates as well. If you jump into Format Cells, and you can do that with ctrl + 1, or possibly right click and simply choose Format Cells... Go to the Number tab, if it's not automatically selected. And we can use Ms and Ds and Ys in a variety of ways, but don't overlook the fact that there are many, many formats in here already. If all the data here in this worksheet is about the current year, maybe you want a format here that…

Contents