P
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
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