Microsoft Office Tutorials and References
In Depth Information
Creating your own date and time formats
Note
At the top of the list of date and time formats are several types that begin with an
asterisk (*). These formats respond to changes in the settings available on the Date and
Time tabs in the Customize Regional Options dialog box, which you access by opening
Windows Control Panel, clicking Regional And Language Options, and then clicking the
Customize button on the Formats tab. All other formats are not affected by these
Control Panel settings.
Most of the date and time formats are easy to understand, but a few special formats exist:
The 13:30 and 13:30:55 time formats use the 24-hour (military) time convention.
The 30:55.2 time format displays only minutes and seconds; Excel displays a fraction
of a second as a decimal value.
The 37:30:55 time format displays elapsed time.
Note
You can press Ctrl+1 to quickly display the Format Cells dialog box.
Creating your own date and time formats
To supplement the standard date and time formats, you can create custom formats by
using the same technique you use to create custom numeric formats.
For more information about custom formats, see “Creating custom number formats” in
Chapter 9, “Worksheet formatting techniques.”
For example, you can create a format that displays all the available date and time
information. The entry 2/24/14 would appear as Tuesday, February 24, 2014 0:00:00.0. To create
this format, follow these steps:
Select the cell that contains the date.
1.
Press Ctrl+1 to display the Format Cells dialog box, and if necessary click the
Number tab.
2.
Select the Custom category.
3.
Search JabSto ::




Custom Search