formatting merged fields

[Guest]

I merged an amount field from excel. My problem is that I can format the
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]

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]...