CODEWITHSUNDEEP
excelstringtextexcel-formulaformat
d3th3n
d3th3n

Reputation: 3

how do I incorporate custom format into TEXT function in excel

I'm using the custom format: Tough (#,##0")";"Delicate ("-#,##0")"

Is there a way of combining the above custom format with the TEXT function so I can concatenate the formatted text into a longer string?

Upvotes: 0

Views: 207

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60224

I cannot use your custom format as written in your question -- returns an error about being an invalid format.

But to use it in the TEXT function, you need to escape the included quotes with another quote.

Assuming your custom format is really: "Tough "(#,##0);"Delicate "(-#,##0)

Then you can use:

=TEXT(A1,"""Tough ""(#,##0);""Delicate ""(-#,##0)")

in the TEXT function

Upvotes: 1

Related Questions