Hi Ed,

Try something like:

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


---
Regards,
Norman


"Ed" wrote in message
...
How do I convert text $123.45 to the number 123.45?

Ed