If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
format numbers in merged document
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? |
#2
|
|||
|
|||
format numbers in merged document
See http://www.gmayor.com/formatting_word_fields.htm
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "confused" wrote in message ... 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? |
#3
|
|||
|
|||
format numbers in merged document
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" wrote: See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "confused" wrote in message ... 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? |
#4
|
|||
|
|||
format numbers in merged document
Alternatively, you can connect to Excel using DDE, which will preserve the
number formatting. See http://homepage.swissonline.ch/cindy...002/MM2002.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "confused" wrote in message ... 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" wrote: See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "confused" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|