Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Percentages from Excel to Word not working per your posting
I could not get the formula listed in
http://www.gmayor.com/formatting_word_fields.htm to work for me. So I upgraded to Word 2007 and I still can not get my merged decimal number to format as a percentage. Any other suggestions? Thank you! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Percentages from Excel to Word not working per your posting
So what result did the fields suggested by Graham give?
The most common problem is that people do not use the special field code braces {} that you can insert usgin ctrl-F9 for every pair of {} in the formula. In this case, supposing your percentage column is called percent, a. what is the result of { MERGEFIELD percent } ? b. if you select { MERGEFIELD percent } then use ctrl-F9 to insert {} around it { { MERGEFIELD percent } } then type extra text to give you the following { ={ MERGEFIELD percent }*100 } what result does that give? Then type a little bit more to give you { ={ MERGEFIELD percent }*100 \#0% } What result does that give? Peter Jamieson "TLH" wrote in message ... I could not get the formula listed in http://www.gmayor.com/formatting_word_fields.htm to work for me. So I upgraded to Word 2007 and I still can not get my merged decimal number to format as a percentage. Any other suggestions? Thank you! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Percentages from Excel to Word not working per your posting
Peter Jamieson wrote:
The most common problem is that people do not use the special field code braces {} that you can insert using ctrl-F9 for every pair of {} in the formula. And that is despite the warning in red and in a larger font at the start of the page -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Percentages from Excel to Word not working per your posting
Yes, I suppose now that hyperlinking/hypertext became widespread it's too
much to ask that people should actually begin at the beginning of anything. But perhaps that's not the problem in this case - you never know :-) Peter Jamieson "Graham Mayor" wrote in message ... Peter Jamieson wrote: The most common problem is that people do not use the special field code braces {} that you can insert using ctrl-F9 for every pair of {} in the formula. And that is despite the warning in red and in a larger font at the start of the page -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
Change paper size; Word changes to invalid margins | New Users | |||
Word & WordPerfect | Microsoft Word Help | |||
WP merge file to Word | Tables |