Format number

Supported in: Batch

Formats a number to a specific number of decimal places.

Expression categories: Cast, Numeric, String

Declared arguments

• Decimal places - The number of decimal places.
  Literal<Integer>
• Number - The number to format.
  Expression<Numeric>

Output type: String

Examples

Example 1: Base case

Description: Formats a number to 2 decimal places. Argument values:

• Decimal places: 2
• Number: 1234.5678

Output: 1,234.57

---

Example 2: Base case

Description: Formats a byte number to 1 decimal place. Argument values:

• Decimal places: 1
• Number: 42

Output: 42.0

---

Example 3: Base case

Description: Formats a float number to 1 decimal place. Argument values:

• Decimal places: 1
• Number: 1234.56

Output: 1,234.6

---

Example 4: Base case

Description: Formats an integer number with no decimal places. Argument values:

• Decimal places: 2
• Number: 1234

Output: 1,234.00

---

Example 5: Base case

Description: Formats a large number to 2 decimal places. Argument values:

• Decimal places: 2
• Number: 123456789.123456789

Output: 123,456,789.12

---

Example 6: Base case

Description: Formats a long number to 1 decimal place. Argument values:

• Decimal places: 1
• Number: 4242424242424242

Output: 4,242,424,242,424,242.0

---

Example 7: Base case

Description: Formats a number with no decimal places. Argument values:

• Decimal places: 0
• Number: 1234.5678

Output: 1,235

---

Example 8: Base case

Description: Formats a short number to 1 decimal place. Argument values:

• Decimal places: 1
• Number: 42

Output: 42.0

---

Example 9: Base case

Description: Formats a large number to 2 decimal places. Argument values:

• Decimal places: 2
• Number: 123456789123456789123456.0

Output: 123,456,789,123,456,789,123,456.00

---

Example 10: Null case

Description: Handles null input. Argument values:

• Decimal places: 2
• Number: number

---

Example 11: Edge case

Description: Formats a number to 50 decimal places. Argument values:

• Decimal places: 50
• Number: 1234.0

Output: 1,234.00000000000000000000000000000000000000000000000000

---