number format - minus sign away from number

  • Thread starter Thread starter yair
  • Start date Start date
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
 
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)
 
Back
Top