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 Number
What I got was 17055, so without the point.
What Am I doing wrong?
Thanks.
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
2 Replies
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 works.
Thanks.
