word/excel mail merge mark 5/14/2007 5:13:03 PM My mail merge returns an monetary amount as 123000. instead of $123,00.00 How do i fix this

Re: word/excel mail merge dave <dlevy[ at ]nyc.rr.com> 5/14/2007 5:19:41 PM On May 14, 1:13 pm, mark <m...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > My mail merge returns an monetary amount as 123000. instead of $123,00.00 > How do i fix this right click on the field, clikc on toggle field codes. make it look like this MERGEFIELD your field name\#$,##0.00

Re: word/excel mail merge "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 5/15/2007 5:10:03 AM See http://www.gmayor.com/formatting_word_fields.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> mark wrote: [Quoted Text] > My mail merge returns an monetary amount as 123000. instead of > $123,00.00 How do i fix this