Text currency to number

[Ed]

How do I convert text $123.45 to the number 123.45?

Ed

 

[Norman Jones]

Hi Ed,

Try something like:

'=============>>
Public Sub Tester()
With Range("A1")
.NumberFormat = "#,##0.00"
.Value = .Value
End With
End Sub
'<<=============

 

[Guest]

Selection.NumberFormat = "0.00"