I've been searching the forum for a specific problem … converting tekst to number. My problem is the tekst has leading spaces and the number found has to be converted from American notation to European notation.
Ive tried several things, but this is what still results partly:
num#(price, '#.##0,00', '.', ',')
The problem I have is that all numbers up to 999.99 are converted corectly, any number above goes wrong and stays tekst. Can anyone help me with this please?