Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Christina
 
Posts: n/a
Default Align $ sign next to numbers

How do you format a cell which contains currency so that the dollar sign is
placed next to the dollar amount rather than left aligned? Example: $5.00
where the dollar sign stays next to the 5, even if the column width is
increased. Thanks!
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Christina

the $ on the formatting toolbar incorrectly tells you that it is "currency"
format, whereas if you choose it and go into format / cells / numbers tab
you will see that it is accounting format - and what you're really after is
currency format ... so choose it from here - ensure that a 'symbol' is
selected as this doesn't seem to be the default and you'll have your $ next
to your numbers.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Christina" wrote in message
...
How do you format a cell which contains currency so that the dollar sign
is
placed next to the dollar amount rather than left aligned? Example:
$5.00
where the dollar sign stays next to the 5, even if the column width is
increased. Thanks!



  #3   Report Post  
N Harkawat
 
Posts: n/a
Default

Use custom format
$0.00

"Christina" wrote in message
...
How do you format a cell which contains currency so that the dollar sign
is
placed next to the dollar amount rather than left aligned? Example:
$5.00
where the dollar sign stays next to the 5, even if the column width is
increased. Thanks!



  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

The suggested format below will not include commas
$5555555.55 formatted with $0.00

The currency format under format, cells, currency
$5,555,555.55 formatted with $#,##0.00_);[Red]($#,##0.00)
$0.55 formatted with $#,##0.00_);[Red]($#,##0.00)

If you do not want a zero for dollars you can code as
$.55 formatted with $#,###.00_);[Red]($#,##0.00)
but you would need to use format, cells, custom

More information on custom formats in
http://www.mvps.org/dmcritchie/excel...m#numberformat
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"N Harkawat" wrote in message ...
Use custom format
$0.00

"Christina" wrote in message
...
How do you format a cell which contains currency so that the dollar sign
is
placed next to the dollar amount rather than left aligned? Example:
$5.00
where the dollar sign stays next to the 5, even if the column width is
increased. Thanks!





  #5   Report Post  
Christina
 
Posts: n/a
Default

THANK YOU, THANK YOU to all who have responded! _c

"David McRitchie" wrote:

The suggested format below will not include commas
$5555555.55 formatted with $0.00

The currency format under format, cells, currency
$5,555,555.55 formatted with $#,##0.00_);[Red]($#,##0.00)
$0.55 formatted with $#,##0.00_);[Red]($#,##0.00)

If you do not want a zero for dollars you can code as
$.55 formatted with $#,###.00_);[Red]($#,##0.00)
but you would need to use format, cells, custom

More information on custom formats in
http://www.mvps.org/dmcritchie/excel...m#numberformat
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"N Harkawat" wrote in message ...
Use custom format
$0.00

"Christina" wrote in message
...
How do you format a cell which contains currency so that the dollar sign
is
placed next to the dollar amount rather than left aligned? Example:
$5.00
where the dollar sign stays next to the 5, even if the column width is
increased. Thanks!








  #6   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Christina,
That's great news. I perhaps should have included the following
which is on my web page (I think) but would be above where I
referenced.

In using Custom formats it is probably best or at least easiest to get
started by choosing a format that comes closest to what you want
and then to use Custom formatting to check what you have for that
cell and to modify the custom format to what you really want.

"Christina" wrote in ...
THANK YOU, THANK YOU to all who have responded! _c



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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com Excel Worksheet Functions 6 April 5th 05 12:40 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM
Converting Numbers to Text properly Shirley Munro Excel Discussion (Misc queries) 1 February 16th 05 04:01 PM


All times are GMT +1. The time now is 11:31 PM.

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

About Us

"It's about Microsoft Excel"