merging with excel

[Stephanie]

I am merging an excel spreadsheet into a publisher doc. The spreadsheet
contains a column of numbers generated from a formula. The formula contains
a # with multiple decimal places. When I merge, the numbers appear in the
publisher doc with 4-5 decimal places. I tried altering the numbers in excel
to have only 2 decimal places, but it still merges with more. How can I
merge them to appear with only 2?

 

[Ed Bennett]

I am merging an excel spreadsheet into a publisher doc. The
spreadsheet contains a column of numbers generated from a formula.
The formula contains a # with multiple decimal places. When I merge,
the numbers appear in the publisher doc with 4-5 decimal places. I
tried altering the numbers in excel to have only 2 decimal places,
but it still merges with more. How can I merge them to appear with
only 2?

Export your Excel sheet as a CSV file and merge against that, instead of the
Excel file.

 

[Stephanie]

Export your Excel sheet as a CSV file and merge against that, instead of the
Excel file.

ok, but how do I export as a csv file? Is it as simple as "saving as"? If
so, then it didn't work.

 

[Martin]

I am having the same problem. Trying to create a Publisher 2003 document that
prints out the marks for my students but their final mark from a spreadsheet
always comes back at 15 decimal places. I also tried all the tips for DDE,
Field codes, using a .csv, changing the format to text, all to no avail.

 

[Martin]

Apparently I answered my own question. If you are using Excel as your data
source document I recommend taking the series of cells that are causing
troubles and using the "FIXED" function to set them to the desired number of
decimal places. It worked for me.

Martin