<div>
Thanks, I spent over an hour looking at Microsoft's unhelpful help but it was like chasing my tail. &nbsp;Your answer was clear and simple! &nbsp;Thanks, Don
</div>


Thanks, I spent over an hour looking at Microsoft's unhelpful help but it was like chasing my tail.  Your answer was clear and simple!  Thanks, Don

<div>
<div class="content wysiwyg-content">
I am using Word and Excel 2007 to do the billing for 40 customers. &nbsp;I have the document that I use to do the merge set up with a column of merge fields that coincide with the Excel columns, such as balance forward, debits, interest, and total. &nbsp;Everything works fine except the debits field, and if the amount is 20.00, it will only displays 20 - while if the number is 20.60, it displays 20.5999999999994. &nbsp;In all of the other merge fields in the document, I get exactly what is displayed in the spreadsheet. &nbsp;For that column in the sheet, I tried copying and paste special / values, formatting as currency, formatting as text (it loses the.00 on 20.00). &nbsp;I suspect that the merge field itself has to be formatted in Word, but can't figure out how to tell it to be a number with 2 decimal places.
</div>
</div>


I am using Word and Excel 2007 to do the billing for 40 customers.  I have the document that I use to do the merge set up with a column of merge fields that coincide with the Excel columns, such as balance forward, debits, interest, and total.  Everything works fine except the debits field, and if the amount is 20.00, it will only displays 20 - while if the number is 20.60, it displays 20.5999999999994.  In all of the other merge fields in the document, I get exactly what is displayed in the spreadsheet.  For that column in the sheet, I tried copying and paste special / values, formatting as currency, formatting as text (it loses the.00 on 20.00).  I suspect that the merge field itself has to be formatted in Word, but can't figure out how to tell it to be a number with 2 decimal places.

Word 2007 merge field does not display numbers correctly

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.