View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Outlook, eh? Outlook, eh? is offline
external usenet poster
 
Posts: 35
Default Formula to Add $ and/or commas

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