View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Formula to Add $ and/or commas

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.



In article ,
Outlook, eh? wrote:

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