Mail merge Excel data to Word: decimal places to infinity and beyond! 2

[Wizdar]

I have a table in Word that has been set up to use data from an Excel table in a mail merge. The Excel numbers, going to 3 decimal places, were entered directly (not the result of a calculation).

When the merge is performed, the numbers appear off by about +/- 0.00...1 (17 decimal places).

The numbers are formatted as such, to 3 decimal places. I’ve also tried formatting the columns as text. No change. There’s far too much data to go in and re-enter.

I’ve checked around here and found similar threads about the subject, but there have been no solutions. I even found a thread I posted a year ago. Nobody found a solution, and I ended up running the same data using a Word 97 mail merge with none of this BS. I no longer have that option, since that computer is history.

Is there no solution to be found?

Office 2003 running on XP Pro.

 

[macropod]

Hi Wizdar,

You can fix this quite simply, by adding a numeric picture switch to the mergefield.

Select the errant field and press Shift-F9 to reveal the field code. It should look something like:
{ MERGEFIELD Data }
Simply add ' \# ,0.000' to the field so that it looks like:
{ MERGEFIELD Data \# ,0.000 }


Cheers

 

[KumarD]

Thanks macropod for the valuable suggestion. I had a problem merging data from Excel into Word. The Excel data is coming from the export of Crystal report (which was formatted to have two digits after decimal from a number that has 10 digits after decimals) and the exported data into Excel looks fine (with only two digits) but when this data is merged into Word it is showing all the 10 digits.

Your suggestion greatly worked. Thanks so much.

KumarD

 

[mickane]

This almost worked - but the number being merged is 1/100th of the actual value when using 2 zeros are used after the decimal, or 1/1000th the originalnumber when 3 zeros are used. If no zeros are used then the number shows no zeros, but this is a financial Excel sheet being merged so accuracy is important ... I'm about to do a search to beter understand merge switches.

 

[mickane]

The answer was simple - we used another comma instead of a period for the decimal place (regional settings)... I now feel so unworthy ... but it's a Friday so I'm okay again