<< Click to Display Table of Contents >>
Format |
Contains a text that represents a mask where object values are displayed. This mask can represent several types of values:
•General: It has no specific format, automatically adapting itself to the specified value
•Number: Displays numbers with an integer and a fraction part. Users may opt for up to 15 decimal places, for using a thousand separator or not, and for displaying negative numbers as signed or between parentheses. For very large or very small numbers, the Scientific format is recommended
•Date: Displays numerical date values (when valid). To represent only time, use the equivalent format
•Time: Displays numerical time values (when valid). To represent only dates, use the equivalent format
•Percentage: Multiplies a number by 100 and adds a percentage symbol. Allows up to 15 decimal places
•Scientific: Displays a number with a mantissa and exponent notation. Ideal for numbers with variable magnitude. Allows up to 15 decimal places
•Special: Allows formatting integers on non-decimal basis (hexadecimal, octal, or binary, for example)
•Other: Allows directly editing a format code, or selecting a previously created format