You're welcome.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Roger Smith" wrote in message
...
the value was 7.55 in the formula bar. But I did already find an article
about switches and I was able to fix it with \###.##. thanks for your
response

"Anne Troy" wrote:

Word pulls the VALUE, not the VIEW of the cell. Click on the cell and
look
at the formula bar. THAT is what Word will pull. See this article to fix
it;
should only take a few moments:
http://www.officearticles.com/word/m...osoft_word.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Roger Smith" Roger wrote in message
...
I have a field in excel that has 7.55 but the mail merge is showing it
as
7.5499999999998. the cell in excel only has the value of 7.55 and I
have
tried formating it as number, currency with 2 decimals and does not
make a
difference. it happens on several lines but not all lines