| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
|
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
Posted to microsoft.public.word.tables
|
|||
|
|||
|
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
Posted to microsoft.public.word.tables
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Truncating time format in Word merged document | Mailmerge | |||
| how to keep date format in merged document same as in data source | Microsoft Word Help | |||
| putting numbers in merged document | Mailmerge | |||
| why can't i type under page numbers? and how to format merged scan | New Users | |||
| How do I format numbers in a Word table, data merged from Excel | Tables | |||
Hybrid Mode
