Microsoft Office Tutorials and References
In Depth Information
Create Custom Date and Time Formats
Chapter 3: Customizing Worksheet Presentation
5 Type the symbols and
text that define your
custom format.
6 Click OK.
5
6
Excel applies the custom
format.
Customize It!
Use the symbols in the following table to build your custom date and time formats.
Symbol
Description
d
Displays a day number without a leading zero (1–31).
dd
Displays a day number with a leading zero (01–31).
ddd
Displays a three-letter day abbreviation (Mon).
dddd
Displays a full day name (Monday).
m
Displays a month number without a leading zero (1–12).
mm
Displays a month number with a leading zero (01–12).
mmm
Displays a three-letter month abbreviation (Aug).
mmmm
Displays a full month name (August).
yy
Displays a two-digit year (00–99).
yyyy
Displays a full year (1900–2078).
h
Displays an hour without a leading zero (0–24).
hh
Displays an hour with a leading zero (00–24).
m
Displays a minute without a leading zero (0–59).
mm
Displays a minute with a leading zero (00–59).
s
Displays a second without a leading zero (0–59).
ss
Displays a second with a leading zero (00–59).
 
Search JabSto ::




Custom Search