Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lee Harris
 
Posts: n/a
Default How to Format Numbers

I'm trying to format some number fields so that positive numbers are
preceeded by a "+" and negative by the "-" and zero by space " " so they all
line up nicely

looking at a text file I have, it seems I want this:

+ (plus sign)
Adds a plus sign to a positive result, a minus sign to a negative result, or
a space if the result is 0 (zero). For example, { = 100 - 90 \# +## }
displays "+10", and { = 90 - 100 \# +## } displays "-10".
%, $, *, and so on



this is my mergefield (an example), but I can't get it to work with the
above format

{ MERGFIELD "INT" }


I tried

{ MERGFIELD \# +## "INT" } and
{ MERGFIELD "INT" \# +## }

but these didn't seem to work

can anyone help?

tx in advance
LeeH


 
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
TOC lists page numbers in Roman format, ref pages in Arabic format Patrick Luijpers Page Layout 2 November 8th 05 10:01 AM
How do I format telephone numbers in Word? ghllag Mailmerge 2 May 5th 05 03:28 PM
Word tables: how do you format numbers? Steel Tables 10 April 5th 05 06:16 PM
How do I format numbers as Currency via Mail Merge? SteveL67 Mailmerge 1 March 3rd 05 05:32 PM
How do you format numbers within a document? bobk2 New Users 2 December 21st 04 04:46 PM


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