View Single Post
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

--

Graham Mayor - Word MVP

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




Bill Edwards wrote:
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