Show/Hide All
Enter the date format to apply to the columns of data that have the Date type format associated with them.
You can right-click this field to apply a color tag to the number format. Color tags are inserted at the beginning of the format string. For multi-part values (separated by semicolons), the color tag is inserted at the beginning of the section regardless of where your cursor is located in the section.
Date Format Specifiers
Format Specifier
Description
d
Displays the day as a number without a leading zero (1-31).
dd
Displays the day as a number with a leading zero (01-31).
ddd
Displays the day as an abbreviation (Sun-Sat).
dddd
Displays the day as a full name (Sunday-Saturday).
m
Displays the month as a number without a leading zero (1-12).
mm
Displays the month as a number with a leading zero (01-12).
mmm
Displays the month as an abbreviation (Jan-Dec).
mmmm
Displays the month as a full name (January-December).
yy
Displays the year as a two-digit number (00-99).
yyyy
Displays the year as a four-digit number (0000-9999).
Format Type
Format
Example
Date
[Blue]mm/dd/yyyy
12/01/2010
Select the number format to apply to the columns of data that have the Number type format associated with them.
To allow different formats for positive, negative, and zero values, the format string can contain between one and three sections separated by semicolons. If the string contains only one section, the format applies to all values. If the string contains two sections, the first section applies to positive values and zeros, and the second section applies to negative values. If the string contains three sections, the first section applies to positive values, the second section applies to negative values, and the third section applies to zeros. If the section for negative values or the section for zero values is empty, the section for positive values is used instead.
You can right-click this field to apply a color tag to the number format. Color tags are inserted at the beginning of the format string. For multi-part values (separated by semicolons), the color tag is inserted at the beginning of the section regardless of where your cursor is located in the section.
Format Specifier
Description
0
This is a digit place holder. If the value being formatted has a digit in the position where the 0 appears in the format string, that digit is copied to the output string; otherwise, a 0 is stored in that position in the output string.
#
This is a digit placeholder. If the value being formatted has a digit in the position where the # appears in the format string, then that digit is copied to the output string; otherwise, nothing is stored in that position in the output string.
.
This is a decimal point. The first decimal point character ( . ) in the format string determines the location of the decimal separator in the formatted value; any additional decimal point characters are ignored.
,
This is a thousands separator. If the format string contains one or more comma characters ( , ), the output will have thousands separators inserted between each group of three digits to the left of the decimal point. The placement and number of comma characters in the format string does not affect the output, except to indicate that thousands separators are wanted.
Note All other characters display as is.
Format Type
Format
Example
Number
[Blue]#,##0.00;[Red]($#,##0.00);$0.00
9,877.09
$8,42.87$0.08
Select the currency format to apply to the columns of data that have the Currency type format associated with them.
The Currency format is equivalent to the Number format, and allows for easy selection of commonly used format settings.
You can right-click this field to apply a color tag to the number format. Color tags are inserted at the beginning of the format string. For multi-part values (separated by semicolons), the color tag is inserted at the beginning of the section regardless of where your cursor is located in the section.
Select the boolean format to apply to the columns of data that have the Boolean type format associated with them.
Boolean formats can be applied to string data as well as numeric data. When applied to strings, the system checks for the following characters at the beginning of the string: 1, 9, T, Y, t, and y.
If any of these characters are found, the column value is considered True; otherwise, False is assumed. For numeric values, zero is considered False, and non-zero values are considered True. The actual format is defined as: TrueString;FalseString, where either the TrueString or FalseString are used to replace the column data value, depending on the column of data.
If the string contains only one section, the format string is used for true values. False values are displayed as is. If the string contains two sections, the format string is used to replace both True and False values.
You can right-click this field to apply a color tag to the number format. Color tags are inserted at the beginning of the format string. For multi-part values (separated by semicolons), the color tag is inserted at the beginning of the section regardless of where your cursor is located in the section.
The Named Value field allows you to locate and replace column values with user-specified values. For example, an application can store column values I, A, and D to represent Inactive, Active, and Disabled. The Named Value formatting allows the view to present the Inactive, Active, and Disabled items when I, A, and D are located.
In the first field, type the value to check for. In the second field, type the substitute value to use when the first value is located. Click Add to add the named value to the list of available named values. Click Delete to remove a named value from the list of available named values. Click Clear to clear the named value from the list of available named values.
This list displays the named values entered at the Named Value fields.
A=Active
