We're using a custom number format which adds some text to the value in
another cell.

in A1 is the value of 20%

in C1 is a link to A1, and has a custom format of: "PROFIT (RATE
OF"0.%)
C1 correctly appears as follows: PROFIT (RATE OF 20%)

The problem is if the value in A1 is a negative number. See if A1 is
-20%,
then C1 appears as: -PROFIT (RATE OF 20.%), with the - sign before the
text.

We need to have the minus sign just before the 2. ie: PROFIT (RATE OF
-20%)


Any ideas on a correct format? And, please no jokes about having a
negative profit margin.
Thanks for any ideas.

Pierre