format field percentage merge Word 2007 from excel 2007

L

LoisInAlaska

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

Doug Robbins - Word MVP

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
 
L

LoisInAlaska

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

Lynnie

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top