numberFormat

Creates a custom-formatted number value. For international
number formatting use LSNumberFormat.
The mask is made up of:
_,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.

numberFormat(number [, mask]) → returns String

Argument Reference for the numberFormat function

number

Required: Yes

mask

Required: No

Examples sample code invoking the numberFormat function


Two decimal places, decimal input

numberFormat(1.23,'__.00')

Expected Result: 1.23


Two decimal places, integer input

numberFormat(123,'__.00')

Expected Result: 123.00


Fork me on GitHub