Mailmerge numbers from Excel Ray 11/15/2008 5:10:03 PM I am trying to mail merge from excel to word to create invoices. The problem involves the merge of numbers into a word document in letter format. The required numbers have now been entered onto the excell spreadsheet manually for a range of people, having initially been calculated by formula. The cells are formatted for number to two decimal places. However, on transfer to word, the numeric data is no longer discrete to two decimal places but is now running to several decimal places. A second subsidiary problem is that the numbers in word are not correctly alligned vertically to form a table. This makes reading the numbers in word a real pain and it looks really unprofessional. Anybody any ideas for solving these dilemas? -- Ray

Re: Mailmerge numbers from Excel "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/15/2008 6:59:05 PM Press Alt+F9 to reveal the field codes and inside the closing } of the merge field that you want formatted to two decimal places, insert the following formatting switch: \# ",0.00" For the alignment issue, use a table with the currency amounts in a separate column that is right aligned. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Ray" <Ray[ at ]discussions.microsoft.com> wrote in message news:BB7B2F1A-D37A-4519-A56D-875706400FAB[ at ]microsoft.com... [Quoted Text] >I am trying to mail merge from excel to word to create invoices. The >problem > involves the merge of numbers into a word document in letter format. The > required numbers have now been entered onto the excell spreadsheet > manually > for a range of people, having initially been calculated by formula. The > cells > are formatted for number to two decimal places. However, on transfer to > word, the numeric data is no longer discrete to two decimal places but is > now > running to several decimal places. > > A second subsidiary problem is that the numbers in word are not correctly > alligned vertically to form a table. This makes reading the numbers in > word a > real pain and it looks really unprofessional. Anybody any ideas for > solving > these dilemas? > -- > Ray

Re: Mailmerge numbers from Excel Ray 11/22/2008 10:55:01 AM Hi Doug This was most helpful and solved the problem. It appears that the difficulty lies within Word mailmerge rather than within Excel formulas. -- Ray "Doug Robbins - Word MVP" wrote: [Quoted Text] > Press Alt+F9 to reveal the field codes and inside the closing } of the merge > field that you want formatted to two decimal places, insert the following > formatting switch: > > \# ",0.00" > > For the alignment issue, use a table with the currency amounts in a separate > column that is right aligned. > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "Ray" <Ray[ at ]discussions.microsoft.com> wrote in message > news:BB7B2F1A-D37A-4519-A56D-875706400FAB[ at ]microsoft.com... > >I am trying to mail merge from excel to word to create invoices. The > >problem > > involves the merge of numbers into a word document in letter format. The > > required numbers have now been entered onto the excell spreadsheet > > manually > > for a range of people, having initially been calculated by formula. The > > cells > > are formatted for number to two decimal places. However, on transfer to > > word, the numeric data is no longer discrete to two decimal places but is > > now > > running to several decimal places. > > > > A second subsidiary problem is that the numbers in word are not correctly > > alligned vertically to form a table. This makes reading the numbers in > > word a > > real pain and it looks really unprofessional. Anybody any ideas for > > solving > > these dilemas? > > -- > > Ray > > >