LSNumberFormat()

Formats a number to the given format mask in the current locale

LSNumberFormat( number=any, mask=string, locale=locale );

Returns: String

Argument Description
number
any, required

Number to format

mask
string, optional

Mask that has to be used for formatting number: dollar sign, comma, and dot are mapped to their locale-specific equivalents.

  • _,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.
locale
locale, optional

Locale to use instead of the locale of the page when processing the function

Examples

There are currently no examples for this function.

See also