Creating custom date formatting


show more Creating custom date formatting provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Working with Dates and Times show less
please wait ...

Creating custom date formatting

In addition to the built-in formatting options for formatting dates and times in Excel you also have the ability to create your own custom formatting. Suppose, for example, the data in Column B here, we might want to have the day of the week included here. Let's recognize if we were to right- click here on Column B and choose Format Cells in the Date category under the Number heading here we do have an option that we'll put in the day of the week along with the date. Now that might be more than what we need here.

If we jump into Custom, that format will be represented here. Now there are some things here we don't want to talk about. We could get pretty far afield looking at some of these other formats, but let's just recognize the use of d's and m's and y's in this display. Let's suppose we do want the day of the week, but maybe we only want a three-letter abbreviation. Three d's will give us a three-letter abbreviation, four d's will spell out the d...

Creating custom date formatting
Video duration: 2m 16s 1h 20m Intermediate

Viewers:

Creating custom date formatting provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Working with Dates and Times

Subject:
Business
Software:
Excel
Author:
please wait ...