numerals in a mail merge

  • Thread starter Stephen Larivee
  • Start date
S

Stephen Larivee

Word 2003 on Windows XP

I have some numbers with varying numbers of decimals. I have them in Excel.
I formated them with two decimal places. When I bring them in to Word as a
data source, they are showing a larger number of decimal places in some
cases. 0.2 in Excel may come out as .200000000001, for example. ( I am
guessing at the number of zeroes)
Next, I copied the numbers and pasted them in NotePad to lose any formating
and then pasted them into a new spreadsheet. But when I bring these into a
mail merge, I am getting the same results.
What am I doing wrong? I would like all numbers to display with consistent
decimal places, preferably two.
Thank you
 
S

Stephen Larivee

Thanks, but I found my help. I did a search and there was the answer, in an
word.mvps.org FAQ section!! Tried it and it worked. Life is good again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
How to count the numbers in a Word document? 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Mail Merge skipping records/sending one at a time 0
Inconsistent formatting of section numbers 0
Grouping Names in Mail Merge 0
Decimal places in mail merge 1
Mail Merge from Excel 1

Top