I'm doing a mail merge from excel to word. I am able to get all the information needed from excel to word without a problem. In excel, I have a formula that gives me a number of years with decimal points, so I round it off to 2 decimal points, which is what I want. Now the problem is when I link it back to word for the mail merge it gives me like 10 decimal points. I only want 2. Can anybody help me out with this? Abit AN8 Socket 939 AMD64 X2 4200 @2.5Ghz Corsair 1Gig Dual-Channel 2x512 MSI Radeon x800 PCI-E Seagate 160Gig SATA WesternDigital 80Gig SATA WesternDigital 160Gig SATA Antec TC

I feel your pain. Every now and then I get a progress report from one of my daughter's teachers via e-mail. The average scores for her projects, tests, etc, are displayed to 14 decimal places. You said: "I round it off to 2 decimal points". How are doing this? If you are simply *displaying* 2 decimal places in Excel, that won't work. Try wrapping your formula in either ROUND() or TEXT(). ROUND() will result in a number, TEXT() will result in text string that looks like a number. =ROUND(your_formula,2) =TEXT(your_formula,"0.00")