Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
1000 separator not showing upon merge
HELP! I have inserted a mergefield in a word document that merges with an
Excel sheet. The row in Excel is formatted as a number with a 1000 separator, but when I merge the document the separator doesn't show. Instead of 100,000 I get 100000. How can I fix this? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
1000 separator not showing upon merge
See Graham Mayor's page at http://www.gmayor.com/formatting_word_fields.htm
-- Peter Jamieson http://tips.pjmsn.me.uk "ANNIEhatesVISTA" wrote in message ... HELP! I have inserted a mergefield in a word document that merges with an Excel sheet. The row in Excel is formatted as a number with a 1000 separator, but when I merge the document the separator doesn't show. Instead of 100,000 I get 100000. How can I fix this? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
1000 separator not showing upon merge
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "ANNIEhatesVISTA" wrote in message ... HELP! I have inserted a mergefield in a word document that merges with an Excel sheet. The row in Excel is formatted as a number with a 1000 separator, but when I merge the document the separator doesn't show. Instead of 100,000 I get 100000. How can I fix this? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
1000 separator not showing upon merge
I had a copy of that document, but it told me to use "{}" brackets. The help
menu from 2007 Word (Vista) told me to use "()" brackets. I was only able to get it to work using "[]" brackets. Hope this can help someone else as it took me hours to figure it out on my own. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "ANNIEhatesVISTA" wrote in message ... HELP! I have inserted a mergefield in a word document that merges with an Excel sheet. The row in Excel is formatted as a number with a 1000 separator, but when I merge the document the separator doesn't show. Instead of 100,000 I get 100000. How can I fix this? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
1000 separator not showing upon merge
What language version of Word are you using? English versions of Worduse
curly brackets as field boundaries {}. In any case you don't have to enter the brackets, you should already have them. Toggle the field display with Alt+F9 and add the switch between the existing brackets. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ANNIEhatesVISTA wrote: I had a copy of that document, but it told me to use "{}" brackets. The help menu from 2007 Word (Vista) told me to use "()" brackets. I was only able to get it to work using "[]" brackets. Hope this can help someone else as it took me hours to figure it out on my own. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "ANNIEhatesVISTA" wrote in message ... HELP! I have inserted a mergefield in a word document that merges with an Excel sheet. The row in Excel is formatted as a number with a 1000 separator, but when I merge the document the separator doesn't show. Instead of 100,000 I get 100000. How can I fix this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line separator in Mail Merge | Mailmerge | |||
How do I merge 1000, 8pg. letr's and print 1st pg. on diff. paper | Mailmerge | |||
Creating a 'separator page' during a mail merge | Mailmerge | |||
Keep 1000 separator in letter merged numbers from excel | Microsoft Word Help | |||
how do i get the 1000 separator on the mail merged document | Mailmerge |