Export (0) Print
Expand All

Examples of Standard Formats for Data Types

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.

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

Note 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 Note

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

Show:
© 2014 Microsoft