Custom Cell Formats
 

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

Custom Cell Formats
 

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

Custom Cell Formats
 

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