Problem with converting text to number

[#1]

Hi

im trying to convert some text to number but it only converts two of my data

the other ones, they dosnt seem to convert,

and they are pure text, as you can see in the image, i have tried NUM() and NUM#() at load and at expression,

but it only converts the 3.6 and 3.8 but the others dosnt seem to work

Do anyone have an idea why is this not working?

Thanks!

[dmitrydv]

‌Could you export your data into XLS?

[vishsaggi]

would it be possible to share an app ?

[mkelemen · Accepted solution]

Hi,

could there be a space in front of the numbers? Try using Trim().

It would help if you can post the source data for the numbers.

BR,

  Matus

[#5]

Thank you very much, i think it was a space.

Trim did the trick.

[tsponagel]

Thanks, the TRIM-Statement was the solution.