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.
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 | Monday, March 03, 1997 8:00 AM 3/03/97 8:00 AM March 3, 1997 Mon 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 |
.gif "Bb266750.vs_note(en-us,office.12).gif") Note |
|---|
| Values entered in a field of a Duration data type with a regular format assume a 24-hour day. |