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 standard format, proceed to step
4.
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.
Choose OK.