Formatting Functions

Name

Category

Arguments

Result

Description

Example

Formatting Functions

Format_Number

NUMBER value, [NUMBER decimal_points], [TEXT decimal_point_character], [TEXT thousands_seperator]

TEXT

Format a number with grouped thousands.

format_number(12000, 2) returns 12,000.00 format_number(13500.75, 2, “.”, “-“) returns 13-500.00

Formatting Functions

Format_Seconds

NUMBER seconds

TEXT

Formats seconds to readable format.

Format_Seconds(300) will return 5 minutes

Format_Seconds(176600) will return 2 days 1 hours 3 minutes 20 seconds

Last updated