How to change commas and decimal points in numbers?

[vecino]

Hello, currently NumberFormat2( fValor, 0,2,2, True) returns, eg 1,234.15
And I need to return: 1.234,15
How I can get it?
Thanks and regards

 

[klaus]

Dim sValor As String
sValor = NumberFormat2( fValor, 0,2,2, True) returns, eg 1,234.15
sValor = sValor.Replace(",", "*")  ' replaces , by *
sValor = sValor.Replace(".", ",")  ' replaces . by ,
sValor = sValor.Replace("*", ".")  ' replaces * by .

Best regards.

 

[vecino]

Thanks, I'll do that.
Although I thought numberformat2 accept any parameters to do so.
No problem, I'll use the traditional method

Thanks