How can I format the number to use 1000 separator (,) and no decimal places.

[Marcegon]

Hi, I am trying to format the numbers below to 1000 separator and round without decimal places.  I want to align the numbers to the right as well.  Any help would be greatly appreciated! 

Input

62170

29722.86

Desired output

62,170

29,723

Thanks.  

[gautiergodard]

Hello @Marcegon 

Please see the attached solution for this issue!

Hope this helps!

**Please like and mark this solution as resolved if this provided the solution to your question**

[DataNath]

There were a couple of solutions provided for this in your thread the other day @Marcegon - did these not work?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-can-I-format-a-number-to-use-1000-...

[Emmanuel_G]

@Marcegon 

Find in attachement the way of doing that by using Tostring and Round functions.