Reply
 
Thread Tools Display Modes
  #1   Report Post  
Laura
 
Posts: n/a
Default How do I fix Mail Merge numbers

I am merging an excel spreadsheet with a letter in word. The number column
in excel is coming across to word as 1621.33335899999 instead of 1621.34. I
have tried reformatting the column in excel, to no avail. Any Suggestions?
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Try this, Laura:
http://www.officearticles.com/word/m...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Laura" wrote in message
...
I am merging an excel spreadsheet with a letter in word. The number

column
in excel is coming across to word as 1621.33335899999 instead of 1621.34.

I
have tried reformatting the column in excel, to no avail. Any

Suggestions?


  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

You need a formatting switch on the merge field - see
http://www.gmayor.com/formatting_word_fields.htm
In this instance the switch you want is \# ",0.00" (remove the comma if you
don't want the thousands separator)

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Laura wrote:
I am merging an excel spreadsheet with a letter in word. The number
column in excel is coming across to word as 1621.33335899999 instead
of 1621.34. I have tried reformatting the column in excel, to no
avail. Any Suggestions?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formating Mail Merge of 10 digit numbers to have parenthasis+dash Omega411 Mailmerge 4 June 20th 05 08:08 AM
Mail merge using Excel's calculated numbers Paul Kendall Mailmerge 1 June 9th 05 08:46 PM
Numbers are continuing on every mail merge letter txt box; want 1, kallee Mailmerge 1 May 24th 05 09:05 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Numbers reformatting during mail merge Sherry Formatting Long Documents 1 December 9th 04 04:47 PM


All times are GMT +1. The time now is 09:49 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"