How come Word is adding zeros to a mail merge number from Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy Toch - 24 May 2006 03:57 GMT

I've set up a mail merge document in Word using an Excel spreadsheet as the
data file, but everytime Word imports the data it adds about 10 zeros
following by a "1", so 23.4 becomes 23.4000000000001. No matter how many
times a reformat the cell to only have 1 decimal place, I get this strange
output number. Has anyone run into this before???

Reply to this Message

Arvi Laanemets - 24 May 2006 05:50 GMT

Hi

Formatting the cell affects only the way the number is displayed, not the
number itself. You have to round values, p.e. adding a new column with
formula =ROUND(ExactValue,1), and use this column as source for MM.

Signature

Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

> I've set up a mail merge document in Word using an Excel spreadsheet as
> the
> data file, but everytime Word imports the data it adds about 10 zeros
> following by a "1", so 23.4 becomes 23.4000000000001. No matter how many
> times a reformat the cell to only have 1 decimal place, I get this strange
> output number. Has anyone run into this before???

Reply to this Message