Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bill Edwards
 
Posts: n/a
Default WD2003: Floating point error with Excel data

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

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Difficulty pasting Excel data into Word table only in XP versions Digitonomy Tables 0 February 28th 05 12:33 AM
How do you keep the currency format when merging data from Excel? MJW Mailmerge 2 February 22nd 05 06:33 PM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 01:52 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"