Mail Merge from excel "-" instead of number zero and "()" for neg
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
"Kate" wrote in message
...
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)?
|