Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
On Fri, 22 Apr 2005 14:39:46 +0100, "Graham Mayor" wrote:
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
How do you keep the currency format when merging data from Excel? | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |