convert text to number

[Wouter_Denckens]

Hi All,

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?

Thanks in advance!

[el_aprendiz111]

Hi

Would you be able to share a sample?

[NhanNguyen · Accepted solution]

Try num#(price, '#,###.#0', '.', ',')

[Wouter_Denckens]

Thanks Nhan!  Why was my script wrong?  I assumed the second part of the num# function is the way it should return the data?