I tried your *1 but it failed. I decided to recheck and found that my conversion formula had left a leading space in the string and that was the cause of my problem. Your *1 worked then as of course did VALUE(cell address) as will the VAL function of VBA. Apologies for wasting your time.
Also thanks for the useful lead into the VBA help topic.