Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
mail merge in word 2007 from excel
Name: marlene Date: June 2, 2009 at 08:35:53 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
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
Name: Jennifer SUMN Date: June 2, 2009 at 09:44:51 Pacific
Reply:
Change the column format in Excel to Text.
EEOC
0
Response Number 2
Name: GavinR Date: June 2, 2009 at 09:56:17 Pacific
Reply:
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: {MERGEFIELD Number}
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.
0
Response Number 3
Name: marlene Date: June 2, 2009 at 11:00:21 Pacific
Reply:
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.
0
Response Number 4
Name: Georgef Date: July 13, 2009 at 17:56:03 Pacific
Reply:
GavinR 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.
George
0
Response Number 5
Name: Mike (by mmcconaghy) Date: July 13, 2009 at 19:24:15 Pacific
Summary: Hi I had a question about a problem we've been having with opening a .dbf file within a word document using the mail merge feature. I'm currently running Microsoft Word (Office) 2000. The problem we'...
Summary: There certainly is. Create your mailing list in Excel, and then open Word to create the Labels. Type "Mail Merge" in Excel Help, and you'll get the exact steps. Life is more painless for those who a...
Summary: I am posting this question for my colleague who had problems in Word 2003 mail merge with Access parameter queries. She was doing mail merge in Word 2003 with documents originally created by Word 2000...
0 
Scansoft PDF
