Merging from Excel to Word

lucas

New Member
Joined
Sep 2, 2002
Messages
1
Prior to changing to XP, we merged pay sheet data from Excel to Word. We could adjust the number decimal places in Excel and the numbers were shown in Word as requested. Now that we are using XP, I have changed the decimal places in Excel, attempted to “Round”, attempted to “Truncate”, attempted to use “change to value”, etc. and when the documents merge, the values are showing 15 or better decimal places. Do you have any suggestions on how I can merge to Word and keep only 2 or 3 decimal places?
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi

Reset the cell to General and tye the value as needed and re do the data source in the merge or re build the toggle field in WORD just in case, if is still wrong re format excels cell and try again

Jack
 

Anne Troy

MrExcel MVP
Joined
Feb 18, 2002
Messages
2,607
I'm not sure which way it is, but I think it's like this...

XP, by default, uses ODBC to connect to Excel, where prior versions used DDE. (I think it's because XP mail merge is to Access by default.) Anyway, open your main doc, then get the data, but tell it you want to use a DDE connection instead...

Let me know if that doesn't help and I'll look it up to find the exact reason.
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
hi Ann im no guu of word as you know, ive highlighted SOURCE ... does this re allocat the ODBC & DNN default??

Or is that just on that connection?

Many thanks Jack
 

Forum statistics

Threads
1,147,497
Messages
5,741,502
Members
423,662
Latest member
Ajmal Khursand

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