After some testing - you should be able to directly change from string to number without using CAST
or CONVERT
.
This worked with the strings "123","456","789". I was able to directly move them from a string field to a number field.
Your issue may lie with the commas - testing this now.