Examples of Standard Formats for Data Types

  • Article

You can format fields that you create with different formats based on the data type. The following table provides a list of some of the formats that Microsoft Outlook includes.

View a complete list of standard formats available for fields

  • In Outlook, on the View menu, point to Current View, and then click Format Columns.

Note

If you do not find the format you want, you can create a custom format with a Formula data type and the Format function.

Data type

Standard format examples

Currency

$12,345.60 or ($12,345.60)
$12,346 or ($12,346)

Date/Time

Tuesday, March 03, 2009 8:00 AM
3/03/2009 8:00 AM
March 3, 2009
Tue 3/3 8:00 AM
8:00 AM

Duration

12h
12 hours
12h (Work Time) (see the Note below)
12 hours (Work Time) (see the Note below)

Integer

1,234

Keywords

Text

Number

All Digits: 1,234.567 or -1,234.567
Truncated: 1,235 or -1,235
Scientific: 1235E+03 or -1235E+03
Computer: 64 K or 128MB or 1 GB

Percent

65.4321%
65.43% or -65.43%
65% or -65%

Text

Text

Yes/No

Yes or No
On or Off
True or False

Note

Values entered in a field of a Duration data type with a regular format assume a 24-hour day.