Format Number

Syntax

Function:
  • FORMAT-NUM(value)
Parameters:
  • value =  a numeric value
Outputs:
  • a formatted string value
Description:
  • The FORMAT-NUM() function converts a number to a formatted string value.
Typical format specifiers include:
Used:
Formula Builderin a Formula Builder

 

Example
Result
Note
FORMAT-NUM(4.9675, '00.00') 04.97
FORMAT-NUM({{numfield}}, '00.0') 23.5  {{numfield}} = 23.5897
pi(). userexternalid(). Generate a Unique ID Code. random(). orgname(). now(). Template Functions. Process Steps. Excel Financial Functions. date(). string(). tanh(). format-date(). round(). Text based Functions. imgurl(). Repeats. Date/Time Functions. sqrt(). Data Conversion.