Format field doesn't transfer

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Hi,

We just updated our Office from '97 to XP and we are
running into this problem:

We are trying to merge excel fields into word. It works
fine until the amount that we are merging has two zeros
after the decimal point. It transfers the other amounts,
e.g. 985.45, but not 985.00.
Also, I have to physically type a dollar sign before the
the field in order for it to show up.

When we were working with office '97 we were doing fine.

Please help,
Ann
 
After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you connect through a different source, you can format the fields in
the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
Hello Ann:

I think you should send this to a Word newsgroup. This is what I found in
Help but I was unable to apply it to get number to format correctly.

Bernard

Formatting by using field codes

To control other aspects of formatting, press ALT+F9 to display field codes,
and then add switches to the merge fields.

For example:

a.. To display the number "34987.89" as "$34,987.89," add the Numeric
Picture switch (\#).
b.. To print client names in uppercase letters, add the Format switch
(\*).
c.. To ensure that the merged information has the same font and point size
you apply to the merge field, add the \* Charformat switch.
 
Back
Top