Excel/Word Mail Merge

April 1, 2009 at 08:39:13
Specs: Windows XP
I am doing a mail merge from excel to word with decimals. The decimals do not show up in the word document (ie., excel 67%, word mail merge becomes .678999). I need to know how to mail the word document become 67%

See More: Excel/Word Mail Merge

Report •

April 1, 2009 at 09:35:57
I think there is a way using merge codes, but the way I've always done it is to create a new column with


Use this field in your merge and it should come through correctly as raw text

Report •

April 1, 2009 at 10:50:52
THANK YOU THANK YOU THANK YOU!! I have been trying this for 2 days and about 6 hours today. You had the most easiest and simpliest solution in the entire world. Just one other question, if you are entering the numbers manually, is there any way that you can type them in orginally as a percentage number? Sometimes we have to manually input the numbers, and sometimes we just use a spreadsheet that is sent to us. Again, from the tip of my toes to the top of my head, thank you for relieving my headache.

Report •

April 1, 2009 at 11:22:10
To clarify, to manually type in the percentage as a text field instead of making a new column and converting the percentage to a text field. Sorry for that. Hope I didn't confuse you.

Report •

Related Solutions

April 2, 2009 at 05:14:31
Apologies if I misunderstand you.

You can always enter a "number" as "text" if you put an apostrophe ' in front of the number. This will stop excel trying to do clever things with it, and just read it plainly as text. So typing:


Should get you what you want.

Report •

April 2, 2009 at 08:39:06
No, I need the answer the both ways. The first answer solved my problem and the mail merge worked perfectly. It i just sometimes that we manually input the information and that would save us a step of creating another column, but when we just use information that is sent to us, I have go ahead and create that column and convert the info to text. Your help has been greatly appreciated.

Report •

April 2, 2009 at 09:59:59
ah then you could use


for your extra column but I'll have a look into mergeformats, I'm sure I had to do it for a colleague a couple of years ago but can't remember what I did!

Report •

April 2, 2009 at 10:14:01
Ah right...try this...

In the word document, press ALT-F9 to show the merge fields (they should appear in curly braces { } like this with the name of the field in the middle)

You need to add the following MERGEFORMAT code (imagine the field is called varpercentage):

{ varpercentage \# "0%" }

I think this should work, not fully tested on my system. Pressing ALT-F9 will get rid of the mergefields and the document will appear as normal again.

Report •

Ask Question