HI..I am using the mailmerge fuction to get get data from excel into word and
I am having trouble with the format of the numbers. I am adding the following
" \# "$,0;($0)"" to the mergefield command and for the +ve numbers the
formating is fine.. but for the -ve numbers, they do show up in paranthesis
but the comma seperators on the numbers dont show up. Can anyone help me with
this.

Thanx

Did you try

\# "$,0;($,0)"

?

(Each part of the format is completely separate)

Peter Jamieson

"siddharth shanghvi" siddharth wrote in
message ...
HI..I am using the mailmerge fuction to get get data from excel into word
and
I am having trouble with the format of the numbers. I am adding the
following
" \# "$,0;($0)"" to the mergefield command and for the +ve numbers the
formating is fine.. but for the -ve numbers, they do show up in
paranthesis
but the comma seperators on the numbers dont show up. Can anyone help me
with
this.

Thanx