Thread: [Solved] Mail Merge Number Error
View Single Post
 
Old 11-08-2012, 04:51 PM
Tamarrissa Tamarrissa is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Nov 2012
Posts: 3
Tamarrissa is on a distinguished road
Default Mail Merge Number Error

Hi,

I'm trying to mail-merge an Excel document into a Word letter. All the numbers in Excel are in 0.00 (accounting) format (and none of them have 'extra digits' that aren't visible, I triple checked this ), but when it merges into the Word document, it merges like this: 14.300000000000001 (should just be 14.30) or 21.739999999999998 (should just be 21.74). It does this for every number.
Any help at all would be greatly appreciated!!
Reply With Quote