WD2003: Floating point error with Excel data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Edwards - 22 Apr 2005 13:01 GMT

Hi,

I've got an Excel 2003 spreadsheet with some data formatted to 1
decimal place, e.g. 10.5

I've also got a Word 2003 mail merge document which used the 1 dp
formatted data in that spreadsheet.

After mail merging , I get floating point errors like
10.500000000000000000001% or
10.499999999999999999999%

Is there anything I can do? I have all of the latest updates to Office
2003 and my O/S (Windows 2000 SP4)

Thanks

Bill

Reply to this Message

Graham Mayor - 22 Apr 2005 14:39 GMT

This is normal and attributable to the way Word connects to Excel data - see
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi,
>
[quoted text clipped - 14 lines]
>
> Bill

Reply to this Message

Bill Edwards - 22 Apr 2005 14:45 GMT

>This is normal and attributable to the way Word connects to Excel data - see
>http://www.gmayor.com/formatting_word_fields.htm

normal? er, OK... I love Microsoft's "Design Features".

thanks for the link Graham, those toggle switches ("\# 0.0" for my
particular issue) on the end of the merge field seem to have done the
trick :)

much obliged to you, sir.

Bill

Reply to this Message