Im using XL 2000

I have a userform which is taking a numerical value from a user in a textbox
named 'Value' and placing it in Worksheets("Names").Cells(newrow, "E") = Value

The value is placed as 'text' and i have to go in and manually convert to a
number.
I would like to automate this programtaically.

Any ideas?

than you
paul.