Custom Cell Formats

C

C Brandt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Number Formats 1
Custom formats 2
Custom Cell Formats 2
Cell Formats 1
Custom Format with multiple conditonals 1
Custom format 1
Excel: leader dots and multiple font formats 0
Custom Number Format for text 8

Top