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.

--
Biff
Microsoft Excel MVP


"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