[Ann]

I'm trying to merge a word document (form letter) with data from a downloaded
Excel database (over 1,500) records. My problem is that I have to merge
various dollar amounts with the letter and after the letters are all merged
there are spaces between the dollar sign and the dollar amount. The command
I'm using currently is Pledge_Amount\# $#,###.00. As long as the dollar
amount is above $1,000.00 it's ok, but when it's below $1,000.00 then there
are extra spaces. Ex. $ 250.00, $ 37.00, $ 5.00. How do I get the dollar
amount next to the dollar sign with using a different switch for each dollar
amount? Any help is appreciated.
--
Ann

[Peter Jamieson]

You only need
Pledge_Amount \# "$,0.00"
or even
Pledge_Amount \# "$,.00"

The "," just tells Word to group by thosands using a comma - you do not have
to put it in the "correct" position in the format for it to work, so you
don't need all those extra "#" signs.

Peter Jamieson

"Ann" wrote in message
...
I'm trying to merge a word document (form letter) with data from a
downloaded
Excel database (over 1,500) records. My problem is that I have to merge
various dollar amounts with the letter and after the letters are all
merged
there are spaces between the dollar sign and the dollar amount. The
command
I'm using currently is Pledge_Amount\# $#,###.00. As long as the dollar
amount is above $1,000.00 it's ok, but when it's below $1,000.00 then
there
are extra spaces. Ex. $ 250.00, $ 37.00, $ 5.00. How do I get the
dollar
amount next to the dollar sign with using a different switch for each
dollar
amount? Any help is appreciated.
--
Ann

[Ann]

Peter,

Thank you so much!!!! You don't know how much time you have saved me every
month when I have to do this part of my job.
--
Ann


"Peter Jamieson" wrote:

You only need
Pledge_Amount \# "$,0.00"
or even
Pledge_Amount \# "$,.00"

The "," just tells Word to group by thosands using a comma - you do not have
to put it in the "correct" position in the format for it to work, so you
don't need all those extra "#" signs.

Peter Jamieson

"Ann" wrote in message
...
I'm trying to merge a word document (form letter) with data from a
downloaded
Excel database (over 1,500) records. My problem is that I have to merge
various dollar amounts with the letter and after the letters are all
merged
there are spaces between the dollar sign and the dollar amount. The
command
I'm using currently is Pledge_Amount\# $#,###.00. As long as the dollar
amount is above $1,000.00 it's ok, but when it's below $1,000.00 then
there
are extra spaces. Ex. $ 250.00, $ 37.00, $ 5.00. How do I get the
dollar
amount next to the dollar sign with using a different switch for each
dollar
amount? Any help is appreciated.
--
Ann