EXCEL - Word question.?

Before you complete the Merge you need to format the merge fields.

Right click the field -> click toggle field codes. You will see something that looks like this:

{ Percentage “{ MERGEFIELD blah }” }

You need to add "\# ##.00" and make it look like this:

{Percentage“{MERGEFIELD blah }" \# ##.00 }

Put the percentage sign in the document text to display that. If you need more help go to Word and in the help menu type "Format Merge" and you will get some options which will provide more examples.

I've run into bugs like this all the time. One major fix is to Save and Close the Word document (it will ask you to save the Excel spreadsheet on the way. Save it, too). Then, open the Word document again.

It refreshes the changes you've made in Excel.

If that doesn't work, you could make a forumula beside the percent column and turn it into a text. For instance, =left(C2,4)&"%"

a million) Integrating Excel with be conscious records in Excel could be merged with be conscious for Mailings lists, variety letters, envelopes, and so on. I often will replica a header row out of Excel, format or not this is conscious and paste it back into Excel. i recognize you may do it formula and macros which I particularly do, yet in certain cases this procedures is speedier you may could also replica tables from Excel and paste the tables in be conscious. it really is giant even as a recipient could no longer have Excel. basically about a all computers now a days contain be conscious yet no longer Excel, that is one extra value, so I do locate this effective 2) Integrating get admission to with Excel the superb achieveable characteristic is that you're able to have your database in get admission to, run queries and make tables. you may then study and administration the ideas in Excel both by technique of exporting your tables or utilising creating use of the study button on the toolbar. I imported a table from Excel into get admission to as grow to have the ability to do a question and then study the most suitable ends up in Excel. Doing the question in Excel could have taken me hours because i could could manually research the ideas and correlate my effects. I had the mission performed in abut 40 5 minutes. yet another large difference is between Excel and get admission to is that get admission to can carry a lot, a lot extra records. 3) Integrating get admission to with be conscious you may export records tables inclusive of an call, take care of, and so on., to be conscious for merging such issues as variety letters, envelopes, and so on. besides the very undeniable actuality that you'll attempt this in get admission to, i stumble upon it extremely clunky. you may also export your records into be conscious and then you've a lot flexiblity with formatting. The toolbars are extra intuitive even as formatting a be conscious record.

You might try rounding the value in your Excel sheet, unless that would interefere with your calculations. That way Excel stores it as a 2 decimal number. When you format the cell, Excel actually stores the full number, and only displays it as a 2 decimal number.

=ROUND(A!,2)