In Word 2002 and 2003, the default connection method is OLEDB, which does
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
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
(e-mail address removed)> wrote in message
news:
[email protected]...