I have a file that I used a text to column to separate numbers by comma, then I used a data cleanse to get rid of any leading and trailing whitespace, plus tabs, line breaks, and whitespace. However, once I use the Select tool to change the numbers from string to a numerical data type, on some of the numbers I get an error that says it is not a number (Field1:11050 is not a number.) and it deletes the number from the cell. I exported the data before applying the Select and looked at the fields and there aren't any additional spaces, characters, etc so not sure why it's not converting. Is there any way I can keep it from deleting the number even if it doesn't convert? Or any ideas on why it won't convert it from a string to a number.
