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 |