Predefined Numeric Formats

The following table describes the predefined numeric formats that you can use.

Format	Description
General Number	Displays the number without a thousand separator.
Fixed	Displays the number with at least one digit to the left and at least two digits to the right of the decimal separator.
Standard	Displays the number with a thousand separator and two digits to the right of decimal separator.
Scientific	Displays the number using standard scientific notation.
Currency	Displays the number using a currency symbol as defined in the International section of the Control Panel. Uses a thousand separator and displays two digits to the right of decimal separator. Encloses negative value in parentheses.
Percent	Multiplies the number by 100 and displays it with a percentage symbol (%) appended to the right. Displays two digits to the right of the decimal separator.
True or False	Displays FALSE for 0, or TRUE for any other number.
Yes or No	Displays No for 0, or Yes for any other number.
On or Off	Displays Off for 0, or On for any other number.