Format
|
Example
|
Description
|
---|---|---|
Fixed
|
3456.79
|
Displays at least one digit. The number of digits shown is always equal to the value specified for Decimal places, padded with zeros if necessary.
|
General Number
|
3456.789
|
Displays the value with the maximum number of decimal places being equivalent to that specified for Decimal places. When this format is selected, trailing zeroes in the decimal places are removed. Also, if no decimal places are needed, the number is printed without the decimal point and any decimal places.
|
Scientific
|
3.46E+03
|
Displays the value in scientific notation.
|
Standard
|
3,456.79
|
Displays the same format as when Fixed is selected except that a thousands separator is used.
|