Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |