Name
CCur Function
Syntax
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.
Return Value
expression
converted to a type of
Currency.
Description
Converts an expression into a type of Currency.
Rules at a Glance
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.
Example
If IsNumeric(sMyNumber) Then curMyNumber = CCur(sMyNumber) End If
Programming Tips and Gotchas
CCur doesn’t prepend or append a currency symbol; for this, you need to use the 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 value 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 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 value is passed as a parameter to the CCur function, CCur correctly converts it to a currency value of 1234.68.
See Also ...
Get VBScript in a Nutshell, 2nd Edition 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.