String to Number = Missing value

[Brain]

HI,

This is a small example.
I have this data, i want to transform string to number.
Result = missing value
Why ?
Thanks
BR
NUMBERS.xlsx (8.1 KB)

[rfeigel]

There are nonprinting characters in your Excel file. Use this regex to exclude them. Whoever is creating files like this needs to be more careful.
String to Number = Missing Value.knwf (82.8 KB)

I left the original columns in place to show the difference. You can replace them if you want.