word/excel mail merge

M

mark

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

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
 
Top