From Text with comma to number

[Mic1979]

Dear all,

I have the following data, e.g. 170,55 (text), and I need to convert it in 170.55 (decimal number).

What I did was:

• I replaced "," with "."
• I converted in the result in Decimal Number

What I got was 17055, so without the point.

What Am I doing wrong?

Thanks.

[Mic1979]

It works.

Thanks.

[Cookistador · Accepted solution]

it is depending on your format

instead of trying to convert number with this approach, you can use 

With the following setting, it will automatically convert number with a comma for the decimal

With this change, I come from

to