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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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,144,288
Messages
5,723,514
Members
422,502
Latest member
barakgahtan

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