Variable being string nor number?

I am getting string formated data from a CSV file and want to convert the data to number format. In order to know the format I am using the typeof instruction. It says the var is a string. Then when using the StrToNum instruction it says that "The function expected a string but found a number". How is this possible when typeof says it is a string ?

But when trying the NumToStr it says "The function expected a number but found a string". What is going on here ? What I am doing wrong ?

NumToStr requires number (or array). You need to understand that TEXT that holds the number such as "123.15" is NOT a number. It is still text (string).

Conversion from string to number is the REVERSE operation from what you are trying to do. You should be using StrToNum instead:

1 Like

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.