Skip to main content Skip to complementary content

FormatNumber

Creates a string from a numeric value as specified by a pattern.

This function returns a String.

Arguments

Value Specify the value to format.

Properties

Pattern Enter the pattern to be used. The following characters are supported:
  • 0: any digit
  • #: any digit, excluding zeroes that can be omitted
  • .: decimal separator
  • -: minus sign
  • ,: grouping separator
  • ;: separates positive and negative sub-patterns
  • %: multiplies the value by 100 and adds % to the string
  • ‰: multiplies the value by 1000 and adds ‰ to the string
  • ¤: currency sign

This property is also available as an argument. If you specify both, the argument value is used and the property value is ignored.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here