String to number Error

Why I cannot change this column to double?

Thank you!

Welcome to the forum @VincentV7.

Did you explicitly specify that the thousands separator is a space? Or did you just leave that field blank?

3 Likes

After 3 hours I figured it out :slight_smile: It turns out that it is not a space between the thousands but ‘no-break space’. I used String Replacer to remove it. And now it works!!

@elsamuel Thank you anyway :slight_smile:

6 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.