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]

Stephanie <Step...@discussions.microsoft.com> was very recently heard
to utter:

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

--
Ed Bennett - MVP Microsoft Publisher

[Stephanie]

"Ed Bennett" wrote:

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]

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

"Martin" wrote:

> 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.