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
|