| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2007 Mail Merge losing number formatting
I am doing a mail merge in Word 2007 and I am losing the number formatting
from Excel. Copy & paste special is not an option as I need the data to remain in Excel as it is. -- mostly confused |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word 2007 Mail Merge losing number formatting
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, originally posted via msnews.microsoft.com "mostly confused" wrote in message ... I am doing a mail merge in Word 2007 and I am losing the number formatting from Excel. Copy & paste special is not an option as I need the data to remain in Excel as it is. -- mostly confused |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word 2007 Mail Merge losing number formatting
Doug,
Thanks, this did help however, it isn't working for my percentages. The decimal ends up in the wrong place. -- mostly confused "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, originally posted via msnews.microsoft.com "mostly confused" wrote in message ... I am doing a mail merge in Word 2007 and I am losing the number formatting from Excel. Copy & paste special is not an option as I need the data to remain in Excel as it is. -- mostly confused . |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word 2007 Mail Merge losing number formatting
The decimal shouldn't be in the wrong place if you follow the instructions,
however much depends on what the field produces without the calculation. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "mostly confused" wrote in message ... Doug, Thanks, this did help however, it isn't working for my percentages. The decimal ends up in the wrong place. -- mostly confused "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, originally posted via msnews.microsoft.com "mostly confused" wrote in message ... I am doing a mail merge in Word 2007 and I am losing the number formatting from Excel. Copy & paste special is not an option as I need the data to remain in Excel as it is. -- mostly confused . |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word 2007 Mail Merge losing number formatting
When I tried the percentage { ={ MERGEFIELD Amount} * 100\# "0% "}, I get "!Syntax Error, {" -- mostly confused "Graham Mayor" wrote: The decimal shouldn't be in the wrong place if you follow the instructions, however much depends on what the field produces without the calculation. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "mostly confused" wrote in message ... Doug, Thanks, this did help however, it isn't working for my percentages. The decimal ends up in the wrong place. -- mostly confused "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, originally posted via msnews.microsoft.com "mostly confused" wrote in message ... I am doing a mail merge in Word 2007 and I am losing the number formatting from Excel. Copy & paste special is not an option as I need the data to remain in Excel as it is. -- mostly confused . . |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word 2007 Mail Merge losing number formatting
All the special field brace pairs {} need to be the sort you can insert
using ctrl-F9. So you can do 1. ctrl-F9 to give you... { } 2. type = * 100 \#0% to give you { = * 100 \#0% } 3. click immediately after the "=" then click ctrl-F9 to give you { = { } * 100 \#0% } 4. Between the new { }, type MERGEFIELD Amount to give you { = { MERGEFIELD Amount } * 100 \#0% } Peter Jamieson http://tips.pjmsn.me.uk On 29/01/2010 16:53, mostly confused wrote: When I tried the percentage { ={ MERGEFIELD Amount} * 100\# "0% "}, I get "!Syntax Error, {" |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word 2007 Mail Merge losing number formatting
Got it - my error CTRL F9 - works like a charm! Thank you, thank you, thank you!! -- mostly confused "Graham Mayor" wrote: The decimal shouldn't be in the wrong place if you follow the instructions, however much depends on what the field produces without the calculation. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "mostly confused" wrote in message ... Doug, Thanks, this did help however, it isn't working for my percentages. The decimal ends up in the wrong place. -- mostly confused "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, originally posted via msnews.microsoft.com "mostly confused" wrote in message ... I am doing a mail merge in Word 2007 and I am losing the number formatting from Excel. Copy & paste special is not an option as I need the data to remain in Excel as it is. -- mostly confused . . |
|
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word 2007 Mail Merge losing number formatting
The requirement to use CTRL+F9 for field brackets is at the top of the web
page in a large red coloured typeface!  -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "mostly confused" wrote in message ... Got it - my error CTRL F9 - works like a charm! Thank you, thank you, thank you!! -- mostly confused "Graham Mayor" wrote: The decimal shouldn't be in the wrong place if you follow the instructions, however much depends on what the field produces without the calculation. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "mostly confused" wrote in message ... Doug, Thanks, this did help however, it isn't working for my percentages. The decimal ends up in the wrong place. -- mostly confused "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, originally posted via msnews.microsoft.com "mostly confused" wrote in message ... I am doing a mail merge in Word 2007 and I am losing the number formatting from Excel. Copy & paste special is not an option as I need the data to remain in Excel as it is. -- mostly confused . . |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word 2007 losing formatting | Page Layout | |||
| Formatting A Number In Mail Merge | Microsoft Word Help | |||
| How do you preserve number formatting in a mail merge? | Mailmerge | |||
| Mail merge number formatting | Mailmerge | |||
| Formatting Number Values from Mail Merge | Mailmerge | |||
Hybrid Mode
