When done modifying the field code, press Alt+F9 again to hide the underlying field codes and, instead, display results. If you want to have the value include a dollar sign, then include that, as well: If you are dealing with larger values and you want to include thousands separators, then your pattern can look like this:
In that case, you could modify your field code to look like this: For instance, let's say you want a very simple pattern that rounds to two decimal points. This is done by using a backslash (\) followed by a hash mark (#), then the pattern you want to use. Now you want to add the formatting switch to your field code. (Note that if the field name has quote marks around it, you should leave those quote marks in place.) Since it probably isn't, you'll see some different field name instead of "MyValue." Further, if there is anything else in the field code besides "MERGEFIELD" and "MyValue", you'll want to delete that other info so that your field code contains just these two elements. This assumes the value being merged from Excel is called "MyValue".
The field code (all the field codes in the document) should expand so that you can see it all, and it will look similar to this: So your first task is to locate, in your merge document, the field that is responsible for actually merging the value from Excel. In order to implement this approach, you'll need to remember that mail merges are made possible through the use of fields-that is how you indicate in a merge document what should be merged and where it should appear. This approach will typically give the best results. This brings us back to the second possible solution, which is to change how the value is formatted in Word. For instance, if an unformatted value in Excel is 987.6, that is what gets passed to Word-a value without the second digit to the right of the decimal point. This, however, could lead to a problem of a different nature in your mail merge-not enough digits. If you go the former route, you'll need to go into your Excel worksheet and modify the actual underlying, formatted number so it contains values no more precise than two decimal places. You can either change what is being merged from Excel or you can change how the value is formatted in Word. To get around this issue there are two possible solutions. Thus, you get the result that Marylea is experiencing. It pulls, instead, the underlying, more precise (unformatted) number. However, when you use mail merge in Word and pull information from the worksheet, it doesn't pull the number that you see in the cell (the formatted number). That doesn't mean that is the number in the actual cell chances are good that it is a much more precise number, such as 1234.5563289 or 1234.562567. Let's say that you see a number such as 1234.56. What you see in an Excel worksheet is, typically, a formatted number. This happens because of how Excel works with numbers. She wonders how she can have the rounded value merged into her Word documents rather than the underlying data that has many more decimal places. In Excel, she can format a cell to round to the nearest two decimal places. Marylea uses mail merge to place information from an Excel worksheet into the merged documents.