value.FormatNumeric
Description
Description
Returns string representation of a numeric value, formatted according to the format specified.
Syntax
Syntax
Function FormatNumeric(format)
Parameters
Parameters
format (input) - the format to use
Return value
Return value
string - the numeric value in the format
Example
Sample code
Dim val
UserVar.value = CDbl( "4123.26" )
val = UserVar.FormatNumeric( "#,###" ) ' the return value: 4,123
val = UserVar.FormatNumeric( "#,###.#" ) ' the return value: 4,123.3
val = UserVar.FormatNumeric( "E" ) ' the return value: 4.12326E+003
See also