CCur Function

CCur Function

CCur(expression)

expression

Use: Required

Data Type: Numeric or String

A string or numeric expression that evaluates to a number between –922,337,203,685,477.5808 and 922,337,203,685,477.5807.

expression converted to a currency data type.

Converts an expression into a currency data type. The currency data type is stored in eight bytes, with a precision to four decimal places.

If the expression passed to the function is outside the range of the Currency data type, an overflow error occurs.
Expressions containing more than four decimal places are rounded to four decimal places.
The only localized information included in the value returned by CCur is the decimal symbol.

If IsNumeric(sMyNumber) Then
    curMyNumber = CCur(sMyNumber)
End If

It's often tempting to use the Val function to return a numeric data type from a string. However, you should always use the correct data type function, which takes account of the computer's regional settings. In particular, CCur can successfully handle currency symbols and thousands separators embedded in a currency string, whereas Val can't. This means, for example, that if the user inputs a string value of $1,200.68, the CCur function can successfully convert it to a currency value of 1200.68, whereas Val returns a value of 0.
CCur doesn't prepend or append a currency symbol; for this, you need to use the Format function or (in VB6) the new FormatCurrency function. CCur does, however, correctly convert strings that include a localized currency symbol. For instance, if a user enters the string "$ 1234.68" into a text box whose Text property is passed as a parameter to the CCur function, CCur correctly returns a currency value of 1234.68.
CCur doesn't include the thousands separator; for this, you need to use the Format function or (in VB6) the new FormatCurrency function. CCur does, however, correctly convert currency strings that include localized thousands separators. For instance, if a user enters the string "1,234.68" into a text box whose Text property is passed as a parameter to the CCur function, CCur correctly converts it to a currency value of 1234.68.

Table of Contents for
CCur Function