number format - minus sign away from number

Y

yair

hello
my numbers are formatted using question marks, so i can center them
and still justify them by the decimal point. for ex. a column of
numbers with 2345678 being the largest of them, will be formatted with
the string:

?,???,??0;-?,???,??0;-

this way i can center the column, and all numbers will straighten to
the right, by the decimal point. zeros appear as hyphens.

the problem is with the minus signs. if on the previous example i will
have -2345, it will look like this: - 2,345 (the minus sign away
from the digits).

any suggestions? i still wish to center the column. if i give this up
it's simple.

thanx
Yair
 
C

Chip Pearson

You can use a number format of

_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

This will align the decimal points for both positive and negative
numbers.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

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

Top