Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Keeping number formats (eg. 5.15%) in Excel/Word Mail Merge
When I try to perform a mail merge from excel to word, the excel cells have
the correct format, eg. decimal places, % and $ signs. When I conduct the merge, I lose the % and $ signs, and numbers are blown out to ~ 15 decimal places. This did not occure with Office 2000. I'm sure I just need to tick a format box or something but I don't know where? |
#2
|
|||
|
|||
Hi ?B?WGltZW5h?=,
When I try to perform a mail merge from excel to word, the excel cells have the correct format, eg. decimal places, % and $ signs. When I conduct the merge, I lose the % and $ signs, and numbers are blown out to ~ 15 decimal places. This question comes up at least daily in this group... See the mail merge FAQ on my website, the section on Word 2002/2003 Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
|
|||
|
|||
Word is now expected to provide the formatting - see
http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Ximena wrote: When I try to perform a mail merge from excel to word, the excel cells have the correct format, eg. decimal places, % and $ signs. When I conduct the merge, I lose the % and $ signs, and numbers are blown out to ~ 15 decimal places. This did not occure with Office 2000. I'm sure I just need to tick a format box or something but I don't know where? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert chapter number with page number in footer? | Microsoft Word Help | |||
Page numbering in footers, Outside margin, Page Number + Number of Pages | Page Layout | |||
How do I get rid of a page number on a Save As\ Text Only doc? | Microsoft Word Help | |||
Maximum number of pages in a word document | Formatting Long Documents | |||
Keeping number series together without line split | Microsoft Word Help |