How do I align numbers where one number has a dollar sign?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I align a column of numbers where the first number has a dollar sign?
Like this,
$280
60
50
Total $390

When I try to add the dollar sign, Excel "shifts" the number slightly more
to the left of the other numbers, resulting in a slightly uneven alignment.
Also, I'd like the dollar sign number to align w/ the total amt. What's the
best way to do this?
 
Probably Excel applies an accounting number format. Select the cell, and
go to the Formatting dialog, Number tab, and select Custom. The Type box
on the right says

$#,##0_);[Red]($#,##0)

The "_)" part of the first format string tells Excel to leave a blank
space as wide as a parenthesis after the number so it lines up with a
negative number in parentheses. You can change the format string to

$#,##0

which will butt the number against the right edge of the cell.
Alternatively, you could format the non-dollar-sign cells with this string:

#,##0_);[Red](#,##0)

which leaves the same space to the right of the number.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top