Article ID: 195659 - Last Review: January 23, 2007 - Revision: 1.1 WD97: How to Use a Conditional Field to Specify a Number of DigitsThis article was previously published under Q195659 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#
Create the following conditional {IF} field:
\# 000## \# 00### \# 0#### | Article Translations
|

Back to the top
