<div>
Try &quot;#,##0&quot;. This will drop all leading zeros except the last one.
</div>


Try "#,##0". This will drop all leading zeros except the last one.

<div>
Hi, Graham,<br />
<br />
Nope, no difference with that change.
</div>


Hi, Graham,

Nope, no difference with that change.

<div>
Sorry, I guess my question turned into a non-issue after all. If you have no objection, Graham, I'll just delete it.
</div>


Sorry, I guess my question turned into a non-issue after all. If you have no objection, Graham, I'll just delete it.

<div>
I discovered a code format that worked for my purposes.
</div>


I discovered a code format that worked for my purposes.

<div>
<div class="content wysiwyg-content">
I've set up a Word doc with form fields that will be used to merge numerical data from Excel. &nbsp;By default, the numbers lose their comma when they appear in Word, so I added a switch to the field code. For example: { MERGEFIELD &nbsp;ADJUST \# ##,### }, where ADJUST is the column name in Excel. &nbsp;The use of ##,### tells Word what the maximum number of digits will be in a number, and where to place the comma. &nbsp;For numbers that don't require all those digits, each unnecessary # is replaced with a space. &nbsp;So, for a small number like 200, the mergefield displays &quot;[space][space]200&quot;. &nbsp;This would be fine if my numbers were in a table, but these numbers are included in sentences, and the extra spaces are not acceptable. Is there an additional switch I can add to the mergefield code that will replace each unnecessary # with NOTHING instead of a space?
</div>
</div>


I've set up a Word doc with form fields that will be used to merge numerical data from Excel.  By default, the numbers lose their comma when they appear in Word, so I added a switch to the field code. For example: { MERGEFIELD  ADJUST \# ##,### }, where ADJUST is the column name in Excel.  The use of ##,### tells Word what the maximum number of digits will be in a number, and where to place the comma.  For numbers that don't require all those digits, each unnecessary # is replaced with a space.  So, for a small number like 200, the mergefield displays "[space][space]200".  This would be fine if my numbers were in a table, but these numbers are included in sentences, and the extra spaces are not acceptable. Is there an additional switch I can add to the mergefield code that will replace each unnecessary # with NOTHING instead of a space?

Extra spaces in number in Word 2007 merge field

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.