Convert Text to Number

[efernandes67]

Hi,

I have the text "Price = 19,75" in a cell "A1".

Using VBA, how can I get the value 19,75 in cell "B1" as number?

Regards,
Elio Fernandes

 

[Scott Huish]

Sub test()
Range("B1") = Mid(Range("A1"), 8) + 0
End Sub