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.

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 Formatfunction.

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 AM3/03/2009 8:00 AMMarch 3, 2009Tue 3/3 8:00 AM8:00 AM
Duration 12h12 hours12h (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.567Truncated: 1,235 or -1,235Scientific: 1235E+03 or -1235E+03Computer: 64 K or 128MB or 1 GB
Percent 65.4321%65.43% or -65.43%65% or -65%
Text Text
Yes/No Yes or NoOn or OffTrue or False

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