decimal places

[Guest]

When I do a mail merge with WORD and EXCEL the number of decimal places in
the merge differes from those in EXCEL. Why is this?

 

[Bernard Liengme]

Sorry for the 'cop out' but this really is a Word problem so please put the
question on one of the Word newsgroups.
best wishes

 

[Dave Peterson]

You could use another column and format it the way you want?

=text(a1,"00.0000")

Then use that in your mail merge.

Debra Dalgleish posted this for a different question:

In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting will be retained.

If you have to 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

(I bet you could modify it for the number of decimal places you want.)

 

[Guest]

Sorry for the 'cop out' but this really is a Word problem so please put the
question on one of the Word newsgroups.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email




Thanks for your help. Will try wirking through WORD and let you know what happens.

 

[Guest]

You could use another column and format it the way you want?

=text(a1,"00.0000")

Then use that in your mail merge.

Debra Dalgleish posted this for a different question:

In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting will be retained.

If you have to 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

(I bet you could modify it for the number of decimal places you want.)