software

Or just an undocumented non-feature;
According to MSFT:
TEXT(value,format_text)
Whe
Format_text is a number format in text form from in the Category box on
the Number tab in the Format Cells dialog box.

So: If Cell A1 has the number 2, in cell B1 I put a formula
=Text(A1,quot;[red]0.00;[blue]0.00quot;)
where
[red]0.00;[blue]0.00 works just fine as a number format from the category
box of the Number tab in the Format Cells dialog box.

Thougths appreciated.
Undocumented non-feature.

Functions return values to their calling cells - they can't change cell
format.

TEXT() returns a text string to the cell according to the specified
format, rather than actually changing the format.

Since the format isn't changed, neither is the displayed result.

Instead of using TEXT(), use Conditional Formatting (see Help) instead.

In article gt;,
headly gt; wrote:

gt; Or just an undocumented non-feature;
gt; According to MSFT:
gt; TEXT(value,format_text)
gt; Whe
gt; Format_text is a number format in text form from in the Category box on
gt; the Number tab in the Format Cells dialog box.
gt;
gt; So: If Cell A1 has the number 2, in cell B1 I put a formula
gt; =Text(A1,quot;[red]0.00;[blue]0.00quot;)
gt; where
gt; [red]0.00;[blue]0.00 works just fine as a number format from the category
gt; box of the Number tab in the Format Cells dialog box.
gt;
gt; Thougths appreciated.

The function takes two parameters, a value/ref and a format;
This is right out of the help system:
Format_text is a number format in text form from in the Category box on
the Number tab in the Format Cells dialog box.
In other words, the program isn't wrong, the help file is?
Thanks for the clarificationquot;JE McGimpseyquot; wrote:

gt; Undocumented non-feature.
gt;
gt; Functions return values to their calling cells - they can't change cell
gt; format.
gt;
gt; TEXT() returns a text string to the cell according to the specified
gt; format, rather than actually changing the format.
gt;
gt; Since the format isn't changed, neither is the displayed result.
gt;
gt; Instead of using TEXT(), use Conditional Formatting (see Help) instead.
gt;
gt;
gt;
gt;
gt; In article gt;,
gt; headly gt; wrote:
gt;
gt; gt; Or just an undocumented non-feature;
gt; gt; According to MSFT:
gt; gt; TEXT(value,format_text)
gt; gt; Whe
gt; gt; Format_text is a number format in text form from in the Category box on
gt; gt; the Number tab in the Format Cells dialog box.
gt; gt;
gt; gt; So: If Cell A1 has the number 2, in cell B1 I put a formula
gt; gt; =Text(A1,quot;[red]0.00;[blue]0.00quot;)
gt; gt; where
gt; gt; [red]0.00;[blue]0.00 works just fine as a number format from the category
gt; gt; box of the Number tab in the Format Cells dialog box.
gt; gt;
gt; gt; Thougths appreciated.
gt;

No, but it's perhaps not intuitive, and perhaps a confusion with the
usage of quot;formatquot; in quot;number formatquot;...

The Help file isn't wrong, in that you can certainly include a format
containing a custom color, like quot;[Blue]0.00;[Red]0.00quot; - i.e., it won't
throw an error. So the Help file is correct.

But, like any other function, TEXT() returns a value to the cell, in
this case a text string. By definition, text strings carry no
font/color/etc. format information. Values are displayed according to
the cell format. So the text string will be formatted in the way the
cell's text format is specified.

In article gt;,
headly gt; wrote:

gt; In other words, the program isn't wrong, the help file is?