change the insert data type from string to integer or float

what if there is two dot, or, there is multiple 0 before dot?