Numeric Formatting Codes

Except for "-" and ".", the formatting and miscellaneous codes do not affect the characters which can be entered; rather, they only affect the way the characters are formatted. Note that unless otherwise indicated, formatting codes only affect the way a field is displayed on the screen and not how it is returned to the calling program.

Value

Description

|#

(bar hash) Disables the automatic display of "0" in a numeric field when nothing entered.

-

(hyphen) Allow minus sign.

.

(period) Allow decimal point.

$

(dollar sign) Currency field.

G

May be useful for aligning decimal points in column of variable precision numbers.

H

Hours field. Like $ but omits the "$" from the display.

M

Thousands separator.

R

Right justify field.

u

LDF-Related Codes.

v

Value range checking.

Z

Zero fill.