Mail Merge using excel formulas being imported into Word

zscottm

New Member
Joined
Jan 21, 2005
Messages
1
I am doing a mail merge using office 2003. When I import all of my excel data into the new word document, all addresses import fine. The data I have problems with is numbers such as $xxx.xx and percentages (10.125%). The numbers will not round and stay in the 2 or 3 decimal points I need in my merge into word. Does anyone have any idea how fix this? I have modified cell settings in excel every which way and still have the problems maintaining the excel formatting in word. I don't have this problem in office 2000, but in xp and 2003 the problem persists.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,351
Office Version
  1. 365
Platform
  1. Windows
In Word you can format your mail merge fields as required.

Check Help for more information.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,072
Messages
5,857,186
Members
431,860
Latest member
Roofing Contractors

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top