Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
cpeiner cpeiner is offline
external usenet poster
 
Posts: 3
Default Delete text precending an empty/zeroed merge field?

Peter,

this is exactly what I was looking for. The Word helpfile was the first
place I looked but either I was unable to search for the correct words or the
Help function was being elusive. Eithe way, thanks for this!

Cheers!

"Peter Jamieson" wrote:

If you are just displaying numbers or blanks, you should be able to use the
numeric field switches (this stuff's in the Word Help file, or used to be)
to do this:

{ MERGEFIELD fieldname \#"p;n;z" }

where p is the format you want for positive values, n is the format for
negative values and z is the format for 0.




 
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
In Word 2003 when mail merge how do I delete an empty field? connie Mailmerge 3 July 23rd 07 05:25 PM
how do i delete an empty footnote? lrhodes Microsoft Word Help 2 May 27th 06 03:18 PM
auto delete row if empty Alicia Tables 1 October 18th 05 11:20 PM
How do I omit an empty date merge field? Phildeman Microsoft Word Help 5 June 13th 05 03:29 PM
Empty Merge fields then substitute text Mary Mailmerge 1 March 14th 05 12:32 PM


All times are GMT +1. The time now is 08:40 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"