From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Create your own customized date and time formats

Create your own customized date and time formats - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create your own customized date and time formats

“

- [Instructor] Excel has any number of different date formats, and on this worksheet, in columns A through D, we're seeing the same date displayed four different ways. Column A has the full expanded date display, with the day of the week spelled out, the month spelled out, day, and four digit year. Column B, see a variation here, column C, the main difference in these two is we see leading zeros in column C for those months before October and those days before the 10th. And in column D a more compact version that only uses two digit years. We can change these anytime we want. You could also have a situation where maybe the dates that you're recording here are all within the same year, you might not want to display even the year. So let's imagine we want to change, for example, what's in column B. We can easily go into format cells by right clicking the selection, or simply pressing Ctrl + 1, either way. If we…

Contents