The Format function formats a numeric or date expression.
Syntax
|
|
The Format function formats a numeric or date expression. |
|
|
Format(expression, formatString) |
|
|
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".
Comments
0 comments
Article is closed for comments.