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

Why dont you use a formula like that
A1 C1
20 ="Profit Rate of "&A1&"%"
-20 ="Profit Rate of "&A2&"%"


"Pierre" wrote:

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

I think you are using the custom format of...
"Profit Margin of" 0%
try...
"Profit Margin of" 0%;"Profit Margin of" -0%
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Pierre" wrote:

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

Gary Brown wrote:
I think you are using the custom format of...
"Profit Margin of" 0%
try...
"Profit Margin of" 0%;"Profit Margin of" -0%
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.




Gary, that worked like a charm! Thanks much. (Igore, yours worked as
well too.)

Pierre