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: