$ sign alignment with negative numbers

[lis]

How do you format a column so that the dollar sign is on
the left hand side and is aligned with all the other ones
even when there are paranthesis around the negative
numbers e.g.
$ 4,625
$ (4,586)
$ 46

 

[Jason Morin]

Select the column, press Ctrl+1, Number tab, click custom
and insert:

$_(* #,##0.00_);[Red]$_(* (#,##0.00);$_(* "-"??_);_(@_)

HTH
Jason
Atlanta, GA

 

[lis]

tysm

-----Original Message-----
Select the column, press Ctrl+1, Number tab, click custom
and insert:

$_(* #,##0.00_);[Red]$_(* (#,##0.00);$_(* "-"??_);_(@_)

HTH
Jason
Atlanta, GA

-----Original Message-----
How do you format a column so that the dollar sign is on
the left hand side and is aligned with all the other ones
even when there are paranthesis around the negative
numbers e.g.
$ 4,625
$ (4,586)
$ 46
.

.

 

[RagDyer]

OR ... just format Accoumting !

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

tysm

-----Original Message-----
Select the column, press Ctrl+1, Number tab, click custom
and insert:

$_(* #,##0.00_);[Red]$_(* (#,##0.00);$_(* "-"??_);_(@_)

HTH
Jason
Atlanta, GA

-----Original Message-----
How do you format a column so that the dollar sign is on
the left hand side and is aligned with all the other ones
even when there are paranthesis around the negative
numbers e.g.
$ 4,625
$ (4,586)
$ 46
.

.