View Single Post
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] aaronep@pacbell.net is offline
external usenet poster
 
Posts: 4
Default eliminating trailing zeroes imported into word document from excel file

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