Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
formatting merged fields
0 views
Skip to first unread message
with formatting merged fields@discussions.microsoft.com Problem with formatting merged fields
Oct 30, 2004, 12:01:05 AM10/30/04
to
I merged an amount field from excel. My problem is that I can format the
fields to decimal places automatically.
fields to decimal places automatically.
So $25.00 show as $25 which is no problem but $25.50 shows as $25.5.
Suzanne S. Barnhill
Oct 30, 2004, 12:09:09 AM10/30/04
to
In Word 2002 and 2003, the default connection method is OLEDB, which does
not preserve number formatting. There are two approaches you can take:
not preserve number formatting. There are two approaches you can take:
1. You can connect via DDE (check Tools | Options | General: Confirm
conversion at Open to be given a choice).
2. You can apply a numeric picture switch to the merge field. See
http://www.gmayor.com/formatting_word_fields.htm
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Problem with formatting merged fields" <Problem with formatting merged
fie...@discussions.microsoft.com> wrote in message
news:87E242B8-FEA1-4822...@microsoft.com...
0 new messages