Microsoft Office Tutorials and References
In Depth Information
Understanding Excel Date and Time Formats
people out, it is easy to fix using the Format Cells dialog. Other times, when
you want the serial number (for example, to calculate elapsed days between
two dates), Excel converts the serial number to a date, indicating, for ex-
ample, that an invoice is past due by February 15 1900 days. When you
get these types of non sequiturs, you can visit the Format Cells dialog.
Understanding Excel Date and Time Formats
It is worthwhile to learn the various Excel custom codes for date and time
formats. Figure 11.35 shows a table of how March 5 would be displayed in
various numeric formats. The codes in A4:A17 are the possible codes for dis-
playing just date, month, or year. Most people know the classic mm/dd/yyyy
format, but far more formats are available. You can cause Excel to spell
out the month and weekday by using codes such as dddd, mmmm d, yyyy. Here
are the possibilities:
mmm Displays the month with two digits. Months before October are dis-
played with a leading zero (for example, January is 01).
m Displays the month with one or two digits, as necessary.
mmm
mmm Displays a three-letter abbreviation for the month (for example,
Jan, Feb).
mmmm
mmmm Spells out the month (for example, January, February).
mmmmm
mmmmm First
letter
of
the
month,
useful
for
creating
JFMAMJJASOND chart labels.
ddd Displays the day of the month with two digits. Dates earlier than the
10th of the month are displayed with a leading zero (for example, the 1st
is 01).
d Displays the day of the month with one or two digits, as needed.
ddd
ddd Displays a three-letter abbreviation for the name of the weekday
(for example, Mon, Tue).
dddd
dddd Spells out the name of the weekday (for example, Monday, Tuesday).
yyy oor y Uses two digits for the year (for example, 15).
yyyy
yyyy oor yyy
yyy Uses four digits for the year (for example, 2015).
Search JabSto ::




Custom Search