thanks
that works wonderful!
tyler

"Dave Peterson" wrote:

You can use a custom format so that you can see two decimal places:
format|cells|number tab|custom category: #,##0.00

But that won't help with your mail merge into MSWord.

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.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"#,##0.00")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

Tyler wrote:

I have prices listed in my exacel data sheet as follows: 1.20, 1.14, 1.30,
1.10, ect.
all of the numbers that end in a zero (1.20, 1.30, 1.10) only display a
value of 1.1 or 1.2 oe 1.3. The data shows up in excel as 1.10 and 1.20, but
the actual value is not that. I have tried to change the formatting but
nothing works. I am mail merging this excel data into word and my prices on
my mail merge are missing the end zero and we can't have that.
Any suggestions?

--

Dave Peterson