LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help on mail merge excel file into word document Lynn Excel Discussion (Misc queries) 6 April 20th 07 05:30 AM
Eliminating the zeroes from the calculation zealot Excel Discussion (Misc queries) 4 November 25th 06 02:41 PM
excel .txt to .cvs, lose trailing zeroes in numeric field stevefromatlanta Excel Discussion (Misc queries) 0 January 10th 06 07:01 PM
Can I insert a word document into a new excel file ? Robyn78 Excel Discussion (Misc queries) 2 August 2nd 05 08:43 PM
Trailing negatives imported from ASCII file. Jeanne Excel Discussion (Misc queries) 3 July 8th 05 05:20 AM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"