Descriptions of the predefined Numeric Formats

Descriptions of the predefined Numeric Formats

These are the descriptions of Numeric Formats:

General Number

A string of digits with no thousand separator.

Currency

Appropriate thousand separator and display two digits to the right of the decimal point.

Fixed

Allow one digit to the left and two digits to the right of the decimal point.

Standard

Appropriate thousand separator and least one digit to the left and two digits to the right of the decimal

Percent

Display the number in percentage.

Scientific

Display Scientific notation.

Yes/No

If the number is 0 then display No; otherwise, display Yes.

True/False

If the number is 0 then display False; otherwise, display True.

On/Off

If the number is 0 then display Off; otherwise, display On.