Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
LoisInAlaska LoisInAlaska is offline
external usenet poster
 
Posts: 2
Default format field percentage merge Word 2007 from excel 2007

I'm trying to merge data from an Excel 2007 worksheet to a Word document.
I've gotten as far as rounding down from .86999999999999... to .86%, but I
want it to read 86%! Help anyone?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default format field percentage merge Word 2007 from excel 2007

Use the following field construction/formatting switch

Press Alt+F9 to toggle the display the fields in the document, then select
the mergefield and Press Ctrl+F9 to enclose it in an additional pair of
field delimiters and then edit it as follows:

{ = { MERGEFIELD fieldname } * 100 \# "0%" }


--
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

"LoisInAlaska" wrote in message
...
I'm trying to merge data from an Excel 2007 worksheet to a Word document.
I've gotten as far as rounding down from .86999999999999... to .86%, but I
want it to read 86%! Help anyone?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
LoisInAlaska LoisInAlaska is offline
external usenet poster
 
Posts: 2
Default format field percentage merge Word 2007 from excel 2007

It did everything except multiply by 100, so it shows up as .89% instead of
89%. thanks, lois

"Doug Robbins - Word MVP" wrote:

Use the following field construction/formatting switch

Press Alt+F9 to toggle the display the fields in the document, then select
the mergefield and Press Ctrl+F9 to enclose it in an additional pair of
field delimiters and then edit it as follows:

{ = { MERGEFIELD fieldname } * 100 \# "0%" }


--
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

"LoisInAlaska" wrote in message
...
I'm trying to merge data from an Excel 2007 worksheet to a Word document.
I've gotten as far as rounding down from .86999999999999... to .86%, but I
want it to read 86%! Help anyone?




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lynnie Lynnie is offline
external usenet poster
 
Posts: 1
Default format field percentage merge Word 2007 from excel 2007

I am a teacher and we have also battled with this problem for the last few
years sinced we switched to XP. (We ended up using Word2000 with Excel 2000
on two of our computers to merge, that helped). Seems like I have FINALLY
found a better solution and IT IS VERY SIMPLE! (Thank you Jeri Weiser,
University of Wisconsin)

In Microsoft Word, from the Tools menu, select Options...
Select the General tab
Select Confirm conversion at Open
Click OK

Now, whenever you open your data source, a dialog box with 4 options will
come up.
Choose the second option: MS Excel Worksheets via CONVERTER.

It takes a while to open, but afterwards it works just
B-E-A-U-T-I-F-U-L-L-Y-!

Now, whenever you open your data source, a dialog box with 4 options will
come up.
Choose the second option: MS Excel Worksheets via CONVERTER.

It takes a while to open, but afterwards it works just
B-E-A-U-T-I-F-U-L-L-Y-!

"LoisInAlaska" wrote:

I'm trying to merge data from an Excel 2007 worksheet to a Word document.
I've gotten as far as rounding down from .86999999999999... to .86%, but I
want it to read 86%! Help anyone?

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
Mail Merge Labels (Word 2007) w/ Excel (2007) aedcone Microsoft Word Help 2 August 11th 08 03:14 PM
Mail Merge Labels (Word 2007) from Excel (2007) aedcone Microsoft Word Help 3 August 8th 08 03:29 PM
Percentage format in merge from excel Lica Mailmerge 7 November 17th 06 12:30 PM
mail merge a percentage from excel into a word Avani Mailmerge 1 April 8th 06 06:36 AM
Percentage format is lost when doing a mail merge in Word natasha Mailmerge 1 December 15th 04 03:52 PM


All times are GMT +1. The time now is 06:53 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"