View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
C Brandt C Brandt is offline
external usenet poster
 
Posts: 92
Default 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