CCur Function

Converts a string expression or numeric expression to a currency expression. The locale settings are used for decimal separators and currency symbols.

CCur(Expression As Variant) As Currency

Currency

Expression: Any string or a numeric expression that you want to convert to a number.
CCur(EMPTY) returns 0.

Sub CCur_example Print CCur( expression := 145.279 * "654" ) Print CCur( -258.0421E+02 ) End Sub