String to price format

I’m getting multiple format of string as:

2 812.02
213.23
18 122,21
30122.7

I need to transform them into this format:

2,812.02
213,23
18,122.21
30,122.70

Is there any simple ways to do it?

1 Like

If MyStr is the name of the string variable, use MyStr.Replace(" ", ",").

1 Like

@MaxyArthes
check below

Regards!

4 Likes

Thanks, seens it before but I was hoping for a easier ways without using custom packages but I guess that the best ways around.

1 Like

actually, is there anyone used to this format?

I’m playing around and I can’t find the format to get ##,###.## (18,232.70)

nevermind, I didn’t had to say what I wanted for the decimal, so it’s was just ###,###

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.