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 from Excel 1
Decimal places in mail merge 1
eliminating trailing zeroes imported into word document from excel file 4
mail merge problem 4
Mail Merge Formating Issues 3
Word 2007 mail merge repeating address problem 0
Format Number Outlook Merge 1
Convert number to text as displayed 3

Top