Custom number format problem

[Pierre]

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

 

[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
(e-mail address removed)
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