Formats an expression using a format template. The template must use the format conventions defined for gobeProductive.
Syntax
TEXT(expression,format-text)
Arguments
expression Text, number, or cell reference to convert to text format. format-text The format template. Must use the standard gobeProductive format conventions (see below) Format Conventions
Character Description # Displays only significant digits. Insignificant zeros are omitted. For example, in the format #.###, 0.010 would be displayed .01. 0 Displays digits regardless of significance. For example, in the format 0.000, 0.010 would be displayed as 0.010. ? Adds a space for insignificant zeros on either side of a decimal point. This is used to ensure decimal points align correctly and that fractions appear correctly formatted. For example, the format # ???/??? would display 1.5 as 1--1/2-- where the dashes represent hard-spaces. $ Dollar sign. Used for currency values. % Percentage sign. Used for percentage formats. ( ) Parenthesis. Used in place of negative sign. In the format (0.00), -1.55 would appear as (1.55). [Red] Indicates that the value is red when negative. In the format [Red](#.##), -1.50 would appear as (1.5). E Scientific notation indicator. In the format 0.00E-00, 0.000000000005 would appear as 5.00E-12. Example
TEXT(1000,"#,###.0;-#,###.0") returns the text 1,000.0