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%

I think there is a way using merge codes, but the way I've always done it is to create a new column with =TEXT(A2,"0%") Use this field in your merge and it should come through correctly as raw text

Jon: 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.

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.

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: '25% Should get you what you want.

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.

ah then you could use =TEXT(VALUE(A2),"0%") 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!