Character Example Explanation
9 9999 Each character represents a place holder for digits.
0 999.00 Used for leading or trailing zeros.
$ $9999 prefixes the number with a dollar sign.
S S9999 Useful for positive and negative numbers in query results.
PR 9999PR Displays negative numbers in angle brackets.
D or . 99D99, 99.99 Places a decimal point in the place where the D or. is.
, 9,999 Places a comma in the place where the , is.
RN or rn RN Displays roman numerals, in upper-or lowercase depending on the case of the format mask.
DATE date Assumes the number in a Julian date, and displays the resulting value in MM/DD/YY format.