I am trying to convert string cell in excel into a double format.
I tried several approaches:
- by using CDbl function - it is not working:
2.by using Double.Parse function - not working as well
3.by using Double.Parse(o, System.Globalization.CultureInfo.InvariantCulture) - I am getting the same error message: Input string was not in a correct format