How do I convert from string to double in an array?

monkeyinquisition

I have an array (string) like this:

1
2
3
4
5
6
7
8
9

And I want to convert it to array (double). How can I do this?

PS Array1(i)=Array2(i) doesn't seem to work!

Oct 31 '06 #1

willakawill

I have an array (string) like this:

1
2
3
4
5
6
7
8
9

And I want to convert it to array (double). How can I do this?

PS Array1(i)=Array2(i) doesn't seem to work!

You must 'cast' the string to a numeric variable using the built in casting functions. In this case you need the CDbl() function

Oct 31 '06 #2