DOCUMENT:Q195659  14-NOV-2000  [word97]
TITLE   :WD97: How to Use Conditional Field to Specify Number of Digits
PRODUCT :Word 97 for Windows
PROD/VER:WINDOWS:97
OPER/SYS:
KEYWORDS:kbdta kbfield winword word97

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Word 97 for Windows 
-------------------------------------------------------------------------------


SUMMARY
=======

This article describes how to specify a numeric format switch within a nested
{IF} field to control the number of leading zeros in a numeric result. The
formula allows you to format numbers that contain an unequal number of digits,
such as 10, 100, and 1000, as numbers that contain an equal number of digits,
such as 0010, 0100, and 1000.

MORE INFORMATION
================

Use a numeric picture switch (\#) to specify the number of digits for the
result. For example, if your number is to contain five digits, use the following
numeric picture switches within the conditional formula:

   \# 0000#
   \# 000##
   \# 00###
   \# 0####

Create the following conditional {IF} field:

   {if { MERGEFIELD number } > "9" { if { MERGEFIELD number } > "99" { if 
   {MERGEFIELD number } > "999" { if { MERGEFIELD number } > "9999" { 
   MERGEFIELD number } { MERGEFIELD number \# 0#### }}{ MERGEFIELD number \# 
   00### }}{ MERGEFIELD number \# 000## }}{MERGEFIELD number \# 0000# }}

Additional query words: nested conditional 8.0 8.00

======================================================================
Keywords          : kbdta kbfield winword word97 
Technology        : kbWordSearch kbWord97 kbWord97Search kbZNotKeyword2
Version           : WINDOWS:97
Issue type        : kbhowto

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2000.