Name |
Arguments |
Return |
Description |
Format_Number |
NUMBER value, [NUMBER decimal_points], [TEXT decimal_point_character], [TEXT thousands_seperator] |
TEXT |
Format a number with grouped thousands. |
Category: |
Formatting Functions |
Name: |
Format_Number |
Arguments: |
NUMBER value, [NUMBER decimal_points], [TEXT decimal_point_character], [TEXT thousands_seperator] |
Return Type: |
TEXT |
Description: |
Format a number with grouped thousands. |
Examples: |
format_number(12000, 2) returns 12,000.00 format_number(13500.75, 2, “.”, “-“) returns 13-500.00 |
|
Format_Seconds |
NUMBER seconds |
TEXT |
Formats seconds to readable format. |
Category: |
Formatting Functions |
Name: |
Format_Seconds |
Arguments: |
NUMBER seconds |
Return Type: |
TEXT |
Description: |
Formats seconds to readable format. |
Examples: |
Format_Seconds(300) will return 5 minutes Format_Seconds(176600) will return 2 days 1 hours 3 minutes 20 seconds |
|