Name
CCur Function
Syntax
CCur(expression
)
-
expression
Use: Required
Data Subtype: 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.
Return Value
expression
converted to a Variant with a
subtype of Currency.
Description
Converts an expression into a Variant with a subtype of Currency.
Rules at a Glance
If the expression passed to the function is outside the range of the Currency data subtype, 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.
Example
If IsNumeric(sMyNumber) Then curMyNumber = CCur(sMyNumber) End If
Programming Tips & Gotchas
CCur
doesn’t prepend or append a currency symbol; for this, you need to use theFormatCurrency
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 value is passed as a parameter to theCCur
function,CCur
correctly returns a currency value of 1234.68.CCur
doesn’t include the thousands separator; for this, you need to use theFormatCurrency
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 value is passed as a parameter to theCCur
function,CCur
correctly converts ...
Get VBScript in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.