Try this:

Sub convertality()
For Each r In Selection
r.Formula = "=" & r.Text
Next
End Sub

--
Gary''s Student - gsnu2007a


"sharmashanu" wrote:

Hi All
I want to convert 10+930.000 to numric value. I have imported
these number and it is saved as charecter. I want the + sign also in
between once it is converted. Thanks all for any help

Regards

Shanu