H
HB
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?
the merge differes from those in EXCEL. Why is this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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
question on one of the Word newsgroups.
best wishes
D
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.)
=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.)
H
HB
Bernard Liengme said: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.
H
HB
Dave Peterson said: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.)