Applying a date-and-time format
You can choose from several common formats to display date-and-time data. You can, for example, display dates as January 19, 2008 11:00:00 AM PST; Jan 19, 2008; or 1/19/08, and so on. This section describes how to select standard and custom date-and-time formats.
How to apply a date-and-time format
|
1
|
Select a column that contains date-and-time data.
|
|
2
|
From the context menu, choose Format→Format Data.
|
|
3
|
On Date column format, select one of the formats from the list. You can select a standard format or define a custom format. The standard and custom formats are described in the next sections.
|
|
If you select a custom format, specify a format code in the next drop-down list, then proceed to step 4.
|
|
4
|
Select a locale from the next drop-down list.
|
