[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