CCur Function

Syntax:
CCur(Num|$)
Group: Conversion
Description:
Convert to a currency value.
Parameter Description

Num|$ Convert a number or string value to a currency value.
Example:

Sub Main
Debug.Print CCur("1E6") ' 1000000
End Sub