word/excel mail merge

[mark]

My mail merge returns an monetary amount as 123000. instead of $123,00.00
How do i fix this

 

[dave]

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

 

[Graham Mayor]

See http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>