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!
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!
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" <[email protected]> wrote in message
news:[email protected]...
> 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!
Use custom format
$0.00
"Christina" <[email protected]> wrote in message
news:[email protected]...
> 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!
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" <[email protected]> wrote in message news:%[email protected]...
> Use custom format
> $0.00
>
> "Christina" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
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" <[email protected]> wrote in message news:%[email protected]...
> > Use custom format
> > $0.00
> >
> > "Christina" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> >
> >
>
>
>
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" <[email protected]> wrote in ...
> THANK YOU, THANK YOU to all who have responded! _c
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks