Dollar sign on left side of cell

Hi there. I've been trying to get the dollar sign to appear on the left hand side of each cell like this:

$ 340,000
$ 560,000

I can only get it to appear right next to the number $340,000
$560,000

thanks for your help

Hi!

Set the cell format to Accounting.

Biff

"kurtis" <kurtis.1w98ac_1128222306.4964@excelforum-nospam.com> wrote in
message news:kurtis.1w98ac_1128222306.4964@excelforum-nospam.com...
>
> Hi there. I've been trying to get the dollar sign to appear on the left
> hand side of each cell like this:
>
> $ 340,000
> $ 560,000
>
> I can only get it to appear right next to the number $340,000
>
> $560,000
>
> thanks for your help
>
>
> --
> kurtis
> ------------------------------------------------------------------------
> kurtis's Profile:
> http://www.excelforum.com/member.php...o&userid=27724
> View this thread: http://www.excelforum.com/showthread...hreadid=472377
>