I would like to apply some number formatting and add some text, let’s say, at the end of a cell. For instance, for the formatting code (with 4 sections):

[Red]General;[Green]General;[Blue]General;” USD” @

I would expect some colored values, any followed by USD text. This is not happening (the text part) !

Please help !

PS: I am not looking for an altenative solution, I would simple like to use what’s written in excel help:

Include a section for text entry    If included, a text section is always the last section in the number format. Include an “at” character (@) in the section where you want to display any text that you type in the cell. If the @ character is omitted from the text section, text that you type will not be displayed. If you want to always display specific text characters with the typed text, enclose the additional text in double quotation marks (” “). For example, “gross receipts for “@

If the format does not include a text section, any non-numeric value that you type in a cell with that format applied is not affected by the format. In addition, the entire cell is converted to text.

​I would like to apply some number formatting and add some text, let’s say, at the end of a cell. For instance, for the formatting code (with 4 sections):[Red]General;[Green]General;[Blue]General;” USD” @I would expect some colored values, any followed by USD text. This is not happening (the text part) !Please help !PS: I am not looking for an altenative solution, I would simple like to use what’s written in excel help:Include a section for text entry    If included, a text section is always the last section in the number format. Include an “at” character (@) in the section where you want to display any text that you type in the cell. If the @ character is omitted from the text section, text that you type will not be displayed. If you want to always display specific text characters with the typed text, enclose the additional text in double quotation marks (” “). For example, “gross receipts for “@If the format does not include a text section, any non-numeric value that you type in a cell with that format applied is not affected by the format. In addition, the entire cell is converted to text.  Read More

​