>Hi all,
>
>I have a string : "123.456,12" euros and i want a number 123456,12 euros
>but if i use Val( mystring ) i have a bad result...

untested..

n = val(chartran(chartran(x, ".", ""), ",", "."))

but that depends a lot on your set point/set separator values ;-)