format numbers in merged document

[confused]

I created a table in a word document. I also created an excel document with
whole numbers. When I try to insert a merge field, the numbers come out with
decimals. How do I make these numbers whole or with 1 decimal?

 

[Suzanne S. Barnhill]

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

 

[confused]

Saw that website yesterday and tried to make sense of it, but couldn't.
Today after your reply just started playing with the switches. Thanks for
the help.

 

[Suzanne S. Barnhill]

Alternatively, you can connect to Excel using DDE, which will preserve the
number formatting. See
http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm