Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Blank fields in Excel become 0 in MailMerge data file

Acharn wrote:
I hate being forced to "top post".


No one is forcing you to do anything. Top or bottom posting is a choice, but
top posting is more convenient to read as the current text is at the top -
and is the default for Outlook Express which most of the regular
contributors to this forum use.

Anyway, thanks for this very helpful answer. The referenced article
has some *very* good stuff, and I'm grateful to find out the reason
for the change in behavior. The developers may not consider this
"broken", but I had never seen any mention of the change and was
taken by surprise. I spent a couple of days floundering until I
remembered the possibility of using a display switch.


The function was changed in Word 2002 so has been around a long time.

Incidentally, the numeric switch I mentioned, "\# ####;'';''",
displays alphabetic characters as well as numbers, if the data field
is not blank, and suppresses the 0.


It is the latter part of the switch after the second colon that suppresses
the 0. The hashes as you have them make no account of thousands separators
and the first quote should go between \# and # thus \# "# if you wish to use
this construct.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



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
Word Mailmerge using Excel Data File a_ryan1972 Mailmerge 1 April 3rd 06 09:21 AM
Correct spacing for blank fields in name mailmerge Harry Weeds Mailmerge 3 March 5th 06 07:58 AM
Why will mailmerge not use all the fields from data source? Jenny H Mailmerge 3 February 20th 06 05:03 PM
Mailmerge:unwanted blank lines caused by empty data fields Mail merge - Empty data field Microsoft Word Help 0 October 5th 05 01:09 PM
blank fields in merg data file Lee Chase Mailmerge 1 September 1st 05 04:41 AM


All times are GMT +1. The time now is 03:21 AM.

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"