CDecIgnErr ConvertValues Function -- Entisoft Tools 2.0 Object Library

<-- Previous || Up || Next -->

C Dec Ign Err Function
Convert Values Class

Public Function CDecIgnErr( _
    ByVal vValue As Variant _
    ) As Variant

"Convert To Decimal Ignore Errors"
Attempt to convert vValue to a Decimal value.
Return vValue as a Decimal value if the conversion was successful.
Return Empty if vValue could not be converted to a Decimal.

Examples:

    CDecIgnErr(34.5) = 34.5
    CDecIgnErr(0) = 0
    CDecIgnErr(-34.5) = -34.5
    IsEmpty(CDecIgnErr(1E300)) = True
    CDecIgnErr("1") = 1
    CDecIgnErr("0") = 0
    IsEmpty(CDecIgnErr("Word")) = True

See also:

    CanBeDecimal Function
    CCurIgnErr Function
    CDblIgnErr Function
    CSngIgnErr Function
    CDec Function (Visual Basic)

vValue: The value which will be converted to Decimal and returned (if conversion is possible). Conversion is not possible if vValue is Null, an Error, an Object, a non-numeric String, or a numeric value out of the range allowed for this data type.
v1.5 Addition: This function is new to version 1.5 of Entisoft Tools.

<-- Previous || Up || Next -->

C Dec Ign Err FunctionConvert Values Class

"Convert To Decimal Ignore Errors" Attempt to convert vValue to a Decimal value. Return vValue as a Decimal value if the conversion was successful. Return Empty if vValue could not be converted to a Decimal.

C Dec Ign Err Function
Convert Values Class

"Convert To Decimal Ignore Errors"
Attempt to convert vValue to a Decimal value.
Return vValue as a Decimal value if the conversion was successful.
Return Empty if vValue could not be converted to a Decimal.