No (existing) number format can accept it. Floating point numbers would also allow only one decimal point. Your number contains 4.
Remove the
.
from your string, and then convert it. Or atleast allow only 1 decimal point in your string.
If you're having one decimal point, you can still convert it to
Double[
^],
Float[
^] etc numbers. Even if you have one decimal point, you will have to convert it to decimal or float, conversion to an integer with a single decimal point would cause the error.
There is a better way of converting the strings to integers and getting to know whether they can be converted or not, using a
TryParse[
^] in your code, which would either return a true if number was converted or a false if there were any errors in the format.
Remember the size of the data type
Even if you convert the string to a numeric data type, the result would be based on the size of the data type. You need to consider the size of the data type you're going to use.
http://msdn.microsoft.com/en-us/library/ms228360(v=vs.90).aspx[
^]