Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 26th 05, 06:31 PM
Carter Devereaux
 
Posts: n/a
Default How do I align numbers where one number has a dollar sign?

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?

  #2   Report Post  
Old June 26th 05, 07:20 PM
Jon Peltier
 
Posts: n/a
Default

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/
_______



Carter Devereaux wrote:

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is DateDiff function in Excel 2002 ? Nigel Welch Excel Worksheet Functions 4 March 4th 05 03:18 PM
Numbers won't sort correctly. FernW Excel Discussion (Misc queries) 1 March 3rd 05 02:46 PM
Random Number Questions Greegan Excel Worksheet Functions 1 January 5th 05 02:00 AM
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 2 December 6th 04 05:01 PM
How to Replace numbers and text with numbers only? Robert Judge Excel Worksheet Functions 3 November 5th 04 04:36 PM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017