FormatNumber(Number: Number[, FormatString: String, RemoveCurrency: Boolean]): String
Formats Number as a string. If Number is Null, returns Null, or returns number formatted in accordance with FormatString. If FormatString is omitted, the default Windows number format will be used. FormatString can either be a domain name or a valid formatting string. See Formatting for acceptable values of FormatString. The RemoveCurrency boolean parameter is optional. True causes all currency related formatting for Number to be stripped, but retains the decimals formatting. False leaves the currency formatting for Number, and is the default if not specified.
FormatNumber function syntax has these named arguments:
Parameter |
Description |
Number |
Required. Number to be formatted. |
FormatString |
Optional. Format string for the number. |
RemoveCurrency |
Optional. If True, removes currency formatting. Defaults to False. |