If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Numbers reformatting during mail merge
I am doing a mail merge from an Excel document. The
field in the document is an hourly salary amount, so it is formatted as a number with 2 decimals. When I set up the merge to Word, however, it shows the field as having 15 decimals. I cannot change the format once it is in Word. I have tried using several different formats while it is still in Excel, before the merge, including a custom format, but no matter how it shows formatted in Excel, when it is merged into Word the 15 decimal places appear. Any ideas? Thanks, Sherry Rome, Georgia |
#2
|
|||
|
|||
Try rounding the data in Excel (unless you are actually paying people in
increments of less than a penny). What you are currently doing is altering the display while leaving the underlying number untouched. You can also apply a picture (format) to your merge field. If your hourly rate in Excel, though, is a calculated field, you do really want to apply the Round function to your result or you can get spreadsheet calculation errors that are not apparent. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Sherry" wrote in message ... I am doing a mail merge from an Excel document. The field in the document is an hourly salary amount, so it is formatted as a number with 2 decimals. When I set up the merge to Word, however, it shows the field as having 15 decimals. I cannot change the format once it is in Word. I have tried using several different formats while it is still in Excel, before the merge, including a custom format, but no matter how it shows formatted in Excel, when it is merged into Word the 15 decimal places appear. Any ideas? Thanks, Sherry Rome, Georgia |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Customize a Mail Merge doc | Neh | Mailmerge | 1 | September 1st, 2004 12:47 AM |
Secured DB for a Word Mail Merge problem | Tony_VBACoder | General Discussion | 1 | August 30th, 2004 10:11 PM |
Secured DB for a Word Mail Merge problem | Tony_VBACoder | Mailmerge | 0 | August 30th, 2004 07:32 PM |
Sorting in Mail Merge Helper is Grayed Out - Inaccessable | Joe Cooke | Mailmerge | 1 | May 25th, 2004 04:35 PM |