Reply
 
Thread Tools Display Modes
  #1   Report Post  
Ximena
 
Posts: n/a
Default 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   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I insert chapter number with page number in footer? Joan Microsoft Word Help 4 May 9th 05 04:00 PM
Page numbering in footers, Outside margin, Page Number + Number of Pages Eric G Page Layout 6 April 22nd 05 12:28 PM
How do I get rid of a page number on a Save As\ Text Only doc? Mike Whitehurst Microsoft Word Help 2 March 24th 05 02:17 PM
Maximum number of pages in a word document Travis75 Formatting Long Documents 5 January 27th 05 06:03 AM
Keeping number series together without line split ryckma2 Microsoft Word Help 1 December 30th 04 06:04 PM


All times are GMT +1. The time now is 09:55 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"