| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
In Word '07, how do I format dollars merged in from Excel?
I have a new version of 2007.
I merge into Word from Excel, but my dollars do not STAY formated, and I cannot figure out how to hard-code the dollar formatting in Word. |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
In Word '07, how do I format dollars merged in from Excel?
You can use a switch such as:
\# "$0.00" after the mergefield. More detail info can be found at Graham Mayor's site: http://www.gmayor.com/formatting_word_fields.htm -- Have A Good Day Rich/rerat Add MS to your News Reader: news://msnews.microsoft.com (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Partnering" wrote in message ... I have a new version of 2007. I merge into Word from Excel, but my dollars do not STAY formated, and I cannot figure out how to hard-code the dollar formatting in Word. |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
In Word '07, how do I format dollars merged in from Excel?
You missed the comma from that switch
 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Rich/rerat wrote: You can use a switch such as: \# "$0.00" after the mergefield. More detail info can be found at Graham Mayor's site: http://www.gmayor.com/formatting_word_fields.htm |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
In Word '07, how do I format dollars merged in from Excel?
Graham Mayor,
I have not had the opportunity to use a mail merge, to place a dollar amt in a Word document that would require a comma in it, lol  -- Have A Good Day Rich/rerat Add MS to your News Reader: news://msnews.microsoft.com (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Graham Mayor" wrote in message ... You missed the comma from that switch -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Rich/rerat wrote: You can use a switch such as: \# "$0.00" after the mergefield. More detail info can be found at Graham Mayor's site: http://www.gmayor.com/formatting_word_fields.htm |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
| How do I format numbers in a Word table, data merged from Excel | Tables | |||
| Cannot go to last record in excel-word merged document | Microsoft Word Help | |||
| mail merged in word w/ address list in excel, now cant open excel | Mailmerge | |||
| Mailmerge in Word, date format in merged doc | Mailmerge | |||
Linear Mode
