mail merge in word 2007 from excel

June 2, 2009 at 08:35:53
Specs: Windows XP
When I merge from my excel spreadsheet to the word document my number changes from 2 decimals to many decimals. 24 becomes 23.999999 etc. My spreadsheet is formatted to 2 decimals and only 2 are entered and it is not a calculation. I even tried saving it as text and it still changes it when it comes into word

See More: mail merge in word 2007 from excel

Report •

June 2, 2009 at 09:44:51
Change the column format in Excel to Text.


Report •

June 2, 2009 at 09:56:17
In Excel remove the formatting.

In word, click on your field containing the number.
Press Shift + F9 to display the Mergefield info.

Should look like this:

Right after the name of your field add \#0.0x (0.0x is two decimal places, 0.00x is Three decimals, and so on.)
It should now look like this.
{MERGEFIELD Number\#0.0x}

Shift + F9

Try you merge now.

Report •

June 2, 2009 at 11:00:21
I already tried the text idea and it didn't work, either.

Using the Shift F9 worked. Thank you Thank you. I can finish my project now.

Report •

Related Solutions

July 13, 2009 at 17:56:03
I would like to thank you for your Response # 2. I have been having this problem for some time now and your fix has corrected my problem.

Thank you very much.


Report •

July 13, 2009 at 19:24:15
A web site you might find interesting:


Report •

August 4, 2009 at 15:45:03
I have been trying your suggestions unsuccessfully. I've typed Shift F9 and tried to format fields for currency or %s with no luck.

Any other suggestions? I can't figure out what I'm missing!

Report •

Ask Question