Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2004

Tip: Looking for answers? Try searching our database.

Numbers in Word have extra decimal places

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
StephenW - 10 Jun 2004 15:01 GMT
I have a mail merge in Word 2002 with an Excel 2002
spread sheet as it data source.  The values in one column
are two decimal place numbers, but when the data is
brought into Word some of the numbers come across with
14 decimal places.  The cell values are all 2 decimal
places and there is no formatting or calculations
done on the column in Excel.  It is not every number
in the column and I can see no pattern as to which ones
get the extra decimal places.

Any Ideas?  I know I can format the field in Word to
get the decimal places back to where they should be, but I
don't see where Word is getting the values.

Another thing I noticed is that in the Data Source dialog
the column order is changed so that a column called "Name"
appears first, even though its the 4 column in Excel.  
I know this will not affect the mail merge, but some of my
users thought there was a problem and brought it up.
Thanks
Graham Mayor - 10 Jun 2004 15:13 GMT
See http://www.gmayor.com/formatting_word_fields.htm.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

> I have a mail merge in Word 2002 with an Excel 2002
> spread sheet as it data source.  The values in one column
[quoted text clipped - 16 lines]
> users thought there was a problem and brought it up.
> Thanks
macropod - 12 Jun 2004 23:50 GMT
Hi Stephen,

If you examine the Excel file, you will find that the problem data does
indeed have the extra digits after the decimal place. You may need to format
the cells as 'general' and expand the column width to see the trailing
digits.

Cheers

> I have a mail merge in Word 2002 with an Excel 2002
> spread sheet as it data source.  The values in one column
[quoted text clipped - 16 lines]
> users thought there was a problem and brought it up.
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.