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!