mail merge-formatted numbers
 

When I used mail merge to merge my letter to my database (spreadsheet), the
numbers that were formatted with two decimal points, the numbers (example)
112.50 appear as 112.5077777777. Why don't the numbers appear as they have
been forwatted? What do I need to do to make them appear as formatted?
--
corum

mail merge-formatted numbers
 

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

rubye wrote:

When I used mail merge to merge my letter to my database (spreadsheet), the
numbers that were formatted with two decimal points, the numbers (example)
112.50 appear as 112.5077777777. Why don't the numbers appear as they have
been forwatted? What do I need to do to make them appear as formatted?
--
corum

--

Dave Peterson

mail merge-formatted numbers
 

Thanks for your comment. I didn't have this problem until we upgraded to
Office 2003. I have formatted, clicked, read, and reread items but still have
the problem. I will keep trying but if anyone has encountered this same
problem, please let me know. We do have an IT Dept. and a Technical Trainer
but no one has the answer.
--
corum


"Dave Peterson" wrote:


Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

rubye wrote:

When I used mail merge to merge my letter to my database (spreadsheet), the
numbers that were formatted with two decimal points, the numbers (example)
112.50 appear as 112.5077777777. Why don't the numbers appear as they have
been forwatted? What do I need to do to make them appear as formatted?
--
corum

--

Dave Peterson

mail merge-formatted numbers
 

You are using MSWord's mailmerge, right?

Did you use MSWord's Mergefield?

Did it look like:
{MERGEFIELD "Price" \# $#,###.00}

You may want to share what you tried.

=====
You could always use another column in excel and a formula like:
=text(a1,"$#,###.00")
or whatever format you want.

rubye wrote:

Thanks for your comment. I didn't have this problem until we upgraded to
Office 2003. I have formatted, clicked, read, and reread items but still have
the problem. I will keep trying but if anyone has encountered this same
problem, please let me know. We do have an IT Dept. and a Technical Trainer
but no one has the answer.
--
corum

"Dave Peterson" wrote:


Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

rubye wrote:

When I used mail merge to merge my letter to my database (spreadsheet), the
numbers that were formatted with two decimal points, the numbers (example)
112.50 appear as 112.5077777777. Why don't the numbers appear as they have
been forwatted? What do I need to do to make them appear as formatted?
--
corum

--

Dave Peterson


--

Dave Peterson