Convert Strings to Double Datatype

I want to input all data as strings, so that I can validate them easier. Then I want to convert the entries that are supposed to be numbers, to Double, so I can perform math functions on them. How do I do this?

Thanks,
Pete S

Comments

  • : I want to input all data as strings, so that I can validate them easier. Then I want to convert the entries that are supposed to be numbers, to Double, so I can perform math functions on them. How do I do this?
    :
    : Thanks,
    : Pete S
    :


    okay, you want to find out if the string is numeric, first.
    then, you want to make it a double

    if isnumeric(string) then
    dblVariable = cdbl(string)
    end if

    now use the variable in your functions.
    hope this helps
    To ERR is human, but to really f**k something up requires a computer...

  • : I want to input all data as strings, so that I can validate them easier. Then I want to convert the entries that are supposed to be numbers, to Double, so I can perform math functions on them. How do I do this?
    :
    : Thanks,
    : Pete S
    :
    '--------------------------------------------------->>>>>>>>>
    Hi,
    you can find your request at www.softricks.5u.com
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories