eliminating trailing zeroes imported into word document from excel file

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "aaronep@xxxxxxxxxxx" <aaronep@xxxxxxxxxxx>
Date: Fri, 08 Jun 2007 17:49:07 -0700

I am using Windows XP, Msft Word vsn 2002, Msft Excel vsn 2002. I
have prepared an excel file
containing numbers and have formatted the cells that contain the
numerals to just 3 decimal places.

However, when I access the Excel file in a word document using Word's
mail merge feature, the numbers appear with approx 10 zeroes following
the decimal number.

I've rechecked the Excel file and only 3 decimal point places are in
the file.

How can I set the Word document up so only 3 decimal places appear?

All help extremely appreciated! This has been most frustrating.

Best, Aaron

.

Follow-Ups:
- Re: eliminating trailing zeroes imported into word document from excel file
  - From: Jay Freedman

Prev by Date: Re: How separate 'connected' words?
Next by Date: Re: Word 2007 Beta - shortcut menus.
Previous by thread: Re: Two correctly spelled words separated by ")"
Next by thread: Re: eliminating trailing zeroes imported into word document from excel file
Index(es):
- Date
- Thread

Relevant Pages

Data truncated when merging from Excel to Word.
... My data is truncated when I am merging from an excel file to a word document. ... I have merged this large of cells before with no problem, ...
(microsoft.public.word.mailmerge.fields)
Re: eliminating trailing zeroes imported into word document from excel file
... There's an article on the Microsoft web site that might help you: ... I am using Windows XP, Msft Word vsn 2002, Msft Excel vsn 2002. ... when I access the Excel file in a word document using Word's ...
(microsoft.public.excel.misc)
eliminating trailing zeroes imported into word document from excel file
... I am using Windows XP, Msft Word vsn 2002, Msft Excel vsn 2002. ... containing numbers and have formatted the cells that contain the ... when I access the Excel file in a word document using Word's ...
(microsoft.public.excel.misc)
Re: eliminating trailing zeroes imported into word document from excel file
... containing numbers and have formatted the cells that contain the ... when I access the Excel file in a word document using Word's ... the display formatting and retrieve the complete contents. ...
(microsoft.public.word.docmanagement)
can I link my Excel Cells to a table in a Word Document
... I would like to link some cells in an Excel File to some Cells in a Word ... Is there an effectict way to do this? ... The Word Document is a living Document which has values changing ...
(microsoft.public.excel.misc)