I have a table that I am populating with data from Excel.
The table is created by using mail merge, and then I paste
the table into the longer document that I am working on.
My problem is that the table contains two long columns of
numbers formatted as currency. When it is merged to a
Word document, the columns retain the dollar sign, but
lose the comma separator for 1000, and it automatically
inserts spaces between the dollar sign and some of the
smaller dollar amounts. For example, $ 5.00 and $10000.
Is there a way to apply the desired formatting to the
entire column? Currently, I have to go in and fix each
cell manually, and that is very laborious.
Thanks, Lee
Suzanne S. Barnhill - 25 Nov 2003 16:24 GMT
Since you're using mail merge for this, you can add a numeric picture switch
to the mail merge field to force the desired formatting. Look at Word's Help
topic "Numeric Picture (\#) field switch" and experiment till you get the
combination that works.
--
Suzanne S. Barnhill
Microsoft MVP (Word)

Signature
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
> I have a table that I am populating with data from Excel.
> The table is created by using mail merge, and then I paste
[quoted text clipped - 11 lines]
>
> Thanks, Lee