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!