value.FormatNumeric

Returns string representation of a numeric value, formatted according to the format specified.

Function FormatNumeric(format)

format (input) - the format to use

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