M
malonline
Word & Excel 2003; Windows XP
When create table in Excel and then mail merge in document, number
fields from Excel often (but not always) show up with 9 decimal places
even though only one or two entered. For example, in Excel, number is
..43 and in the Word merge document it appears as 0.42299999999999999.
Tried formating multiple ways in Excel to correct (including formatting
the numbers as text) and nothing works. There seems to be no logic to
when it does this and when it doesn't. Has anyone experienced this?
What do I do?? I even had the same problem if I used an Access table
as the data source. Did not have the problem if a Word table was data
source, but this wouldn't really work for my situation.
Thanks for any insight!
When create table in Excel and then mail merge in document, number
fields from Excel often (but not always) show up with 9 decimal places
even though only one or two entered. For example, in Excel, number is
..43 and in the Word merge document it appears as 0.42299999999999999.
Tried formating multiple ways in Excel to correct (including formatting
the numbers as text) and nothing works. There seems to be no logic to
when it does this and when it doesn't. Has anyone experienced this?
What do I do?? I even had the same problem if I used an Access table
as the data source. Did not have the problem if a Word table was data
source, but this wouldn't really work for my situation.
Thanks for any insight!