Decimal points on an excel mail merge

[Wishart1]

I am having trouble with a decimal place or point showing up on a few fields
when I merge my excel info into the word document that is my letter. I never
had a problem when I was using Windows 97, but now that we have been upgraded
to XP it has been a bit more difficult. My excel spreadsheet has about 10
columns of which are address, name, zipcode, loan number, and a few others.
My problem comes up when I merge the excel fields into word and the decimal
place shows up after the zipcode or loan number. Example: Zipcode=22030.0
orLoan number shows up as 76123456.0, The .0 should not be there. I have
done everything I can possibly think of to fix it. Can someone please save
me? Th

Thank you,
Scott Wishart
703-641-6253

 

[Doug Robbins]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP