Formats a number using a specified format
Syntax
Public Function FormatNumber (ByVal sNumber As String, _
Optional ByVal sDecSep As String = "", _
Optional ByVal sValSep As String = "", _
Optional ByVal fixInt As Integer = -1, _
Optional ByVal fixDec As Integer = -1, _
Optional ByVal bSgn As Boolean = False, _
Optional ByVal bAutoDecSep As Boolean = True, _
Optional ByVal bAutoValSep As Boolean = True) As String
Parameters
| Parameter |
Description |
| ByVal sNumber As String |
The number (in string format) |
| Optional ByVal sDecSep As String = "" |
The decimal separator to use, leave blank to use the one used by the system |
| Optional ByVal sValSep As String = "" |
The valute separator, leave blank to use the one used by the system |
| Optional ByVal fixInt As Integer = -1 |
Number of fixed digit to use for the integer part of the number, pass -1 to not use |
| Optional ByVal fixDec As Integer = -1 |
Number of fixed digit to use for the decimal part of the number, pass -1 to not use |
| Optional ByVal bSgn As Boolean = False |
True for using sign, False otherwise |
| Optional ByVal bAutoDecSep As Boolean = True |
True for using automatic decimal separator |
| Optional ByVal bAutoValSep As Boolean = True |
True for using automatic valute separator |
|