Microsoft Office Tutorials and References
In Depth Information
Create Custom Date and Time Formats
Create Custom Date
and Time Formats
You can enhance your worksheet display of
dates and times by creating your own custom
date and time formatting.
Date and time formats determine how Excel
displays data values and time values in a range.
For a date, the date format determines whether
Excel displays the value with the year, month,
date, or all three, and whether you see short
values such as Fri or long values such as Friday.
For a time, the time format determines
whether Excel displays the value with the hour,
minute, second, or all three.
Although the built-in date and time formats
are fine for most applications, you might need
to create your own custom formats. For
example, you might want to display just the
day of the week (for example, Friday). To do
this, you can create custom date and time
formats. You can do so either by editing an
existing format or by creating your own
format. The formatting syntax and symbols are
explained in the Tip.
1 Select the range you
want to format.
2 Click the Home tab.
3 In the Number group,
click the dialog box
The Format Cells dialog
box appears with the
Number tab selected.
If you want to base your
custom format on an
existing format, click
either the Date or Time
category and then click
4 Click Custom.