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

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


--
Regards,

Peo Sjoblom




"Outlook, eh?" wrote in message
...
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