NumberFormat

Creates a custom-formatted number value. For international number formatting use LSNumberFormat. [mask - quicky] _,9 Digit placeholder; . decimal point; 0 Pads with zeros; ( ) less than zero, puts parentheses around the mask + plus sign before positive number minus before negative - a space before positive minus sign before negative , Separates every third decimal place with a comma. L,C Left-justifies or center-justifies number $ dollar sign before formatted number. ^ Separates left and right formatting.

Returns: string

Usage

NumberFormat( number [, mask ] )

Arguments

Argument Description
number
(any, required)

A number.

mask
(string, optional)

_ = optional digit . = decimal point 0 = mandatory digit

Examples

#numberFormat(1.23,'__.00')# = 1.23
#numberFormat(123,'__.00')# = 123.00

See also