0
How to convert decimal String to decimal number
Hayhay,
I wanted to work with a number. Then I noticed, that the number is a string (value: 10,50). So I tried making a number out of it. But turns out:
number() can only handle digits, not a decimal numbers
formatDate() has no option to convert a string
I tried splitting it with
item(split(string, ","), 0)
item(split(string, ","), 1)
But could't put it back being a number.
Help is appreciated.
1 Antwort
-
let myText := split('Number as Text', ","); number(item(myText, 0)) + number(item(myText, 1)) / 100
Content aside
- Status Answered
- vor 2 JahrenZuletzt aktiv
- 1Antworten
- 60Ansichten
-
2
Folge bereits