Mail Merge from excel "-" instead of number zero and "()" for neg

[Kate]

Two questions for numbers from excel datasource

How do I change a "0" from a dash "-"?

How do I show negative currency number as $(25.46) or ($45.67)?

 

[Doug Robbins - Word MVP]

Use Alt+F9 to toggle the display of field codes and inside the closing }
insert the following formatting switch

\# "$,0.00;($,0.00);-"

or

\# "$,0.00;$(,0.00);-"

Alt+F9 again to toggle off the display of the field codes.
--
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