Format Function

The Format function formats a numeric or date expression.

Syntax

Format(expression, formatString)

The Format function formats a numeric or date expression.

Arguments

expression Expression - A numeric or date expression.

formatString String - A string representing the format to which the expression is to be converted.

Remarks

• Microsoft defined custom and standard format specifiers can be used to build a format string.
• Numeric formats -- https://msdn.microsoft.com/en-us/library/427bttx3.aspx
• DateTime formats -- https://msdn.microsoft.com/en-us/library/97x6twsz.aspx

Example:

Format(10344, "$##,##0.00"); // returns "$10,334.00"

Example:

Format(#01/18/2008#, "D"); // returns "Friday, January 18, 2008"