URGENT! Excel adding decimal places and #'s

[Guest]

I am trying to merge data from Excel to Publisher wusing the mail merge
wizard. However for some reason some of the numbers have added numbers after
the decimal. These numbers do NOT exsist in the excel data, the cells are
formated to be numerical with 2 decimal places. Also some of the numbers are
being truncated - the zeros are being dropped.

This happens no matter if I merge to a new document in PUB or WORD. I have
used the same workbook before without this problem. I have even tried
clearing all formatting and formulas from the cells and reentering the data -
no go.

PLEASE HELP! This is very important - I need it fixed asap!

 

[Debra Dalgleish]

I don't use Publisher, but here's the advice for a similar problem with
a Word Mail Merge. Perhaps some of it will be relevant:

'========================
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
'==================