Format

<< Click to Display Table of Contents >>

 

Format

Text Contains a text that represents a mask, in which this object's 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

Was this page useful?