Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TLH TLH is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Change paper size; Word changes to invalid margins OhioTech New Users 10 July 6th 06 02:00 PM
Word & WordPerfect MrsMac Microsoft Word Help 5 June 10th 06 03:14 AM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM


All times are GMT +1. The time now is 07:56 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"