Formula to Add $ and/or commas

[Outlook, eh?]

Hi,
I have a column of amounts
5000
75
750
10000

and would like them to be
$5,000
$75
$750
$10,000

I can't use format cells, because I actually want to add the $ and commas,
not just change their format for a merge into word.

Any help would be greatly appreciated!
Bryce

 

[T. Valko]

You can use another column and enter this formula:

=DOLLAR(A1,0)

Drag down as needed.

Note that this converts the numeric values to *TEXT* values so you need to
take that into account if you want to do any downstream calculations.

 

[Bob Phillips]

=text(a1,"$#,##0")

and copy down

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[JE McGimpsey]

If you're using them as a merge, simply format the merge field in Word
appropriately. That way you don't need to change your source numbers
into text.

See the "Format merged data" topic in Word help.

 

[Peo Sjoblom]

=TEXT(A2,"$#,##0.00")

then copy and paste as values, note that it will be text

 

[Outlook, eh?]

Thanks so much everyone! =Dollar(A1,0) worked like a charm!