Microsoft Office Tutorials and References
In Depth Information
Enhancing Reporting with Custom Number Formatting
Formatting dates and times
Custom number formatting isn’t just for numbers. You can also format dates and times. As you can
see in Figure 2-17, you use the same dialog box to apply date and time formats using the Type input.
Figure 2-17: You can also format dates and times using the Format Cells dialog box.
Figure 2-17 demonstrates that date and time formatting involves little more than stringing
datespecific or time-specific syntax together. The syntax used is fairly intuitive. For example, DDD is the
syntax for the three-letter day, mmm is the syntax for the three-letter Month, and yyyy is the syntax
for the four-digit year.
There are several variations on the format for days, months, years, hours, and minutes. Take some
time and experiment with different combinations of syntax strings.
Table 2-1 lists some common date and time format codes you can use as starter syntax for your
reports and dashboards.
Table 2-1 : Common Date and Time Format Codes
Format Code
1/31/2013 7:42:53 PM Displays As
m
1
mm
01
mmm
Jan
mmmmm
January
mmmmm
J
dd
31
ddd
Thu
dddd
Thursday
yy
13
yyyy
2013
mmm-yy
Jan-13
dd/mm/yyyy
31/01/2013
dddd mmm yyyy
Thursday Jan 2013
Search JabSto ::




Custom Search