Hi Guys:

Quick question on Custom Cell Formats:
What I would like to do is present a percentage figure, preceded a
discriptor. The custom format that I used was:
"I-ALL "0.00%
With an expected output for a negative 0.52% of I-ALL -0.52%
What I got was -I-ALL 0.52%.
Is there any way to get the sign of the number to appear just before the
number instead of before the discriptor?

Regards,
Craig

One way:

Format/Cells/Number/Custom "I-ALL "0.00%;"I-ALL "-0.00%


In article ,
"C Brandt" wrote:

Hi Guys:

Quick question on Custom Cell Formats:
What I would like to do is present a percentage figure, preceded a
discriptor. The custom format that I used was:
"I-ALL "0.00%
With an expected output for a negative 0.52% of I-ALL -0.52%
What I got was -I-ALL 0.52%.
Is there any way to get the sign of the number to appear just before the
number instead of before the discriptor?

Regards,
Craig

Thank you very much!

"JE McGimpsey" wrote in message
...
One way:

Format/Cells/Number/Custom "I-ALL "0.00%;"I-ALL "-0.00%


In article ,
"C Brandt" wrote:

Hi Guys:

Quick question on Custom Cell Formats:
What I would like to do is present a percentage figure, preceded a
discriptor. The custom format that I used was:
"I-ALL "0.00%
With an expected output for a negative 0.52% of I-ALL -0.52%
What I got was -I-ALL 0.52%.
Is there any way to get the sign of the number to appear just before the
number instead of before the discriptor?

Regards,
Craig