format-num()

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:

• 0  – Replaces with digit or zero if none
• #  – Replaces with digit or nothing if none
• .  – Sets the decimal separator position
• ,  – Sets grouping operator position
• Learn more about format specifiers from Microsoft

Used:

Example

Result

Note