Forum Discussion
Solved
From Text with comma to number
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 N...
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
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