Convert a String to Currency

Use CCur to convert a string to the Currency type. CCur is locale aware.

Dim s As String

s = "$120.15"

Dim cc As Currency

cc = CCur(s)

Print cc  ' prints "120.15"