Format the numbers before writing

[Kallis]

Hello Everyone

I need to format the numbers before they are written into an Excel.

Input	Expected Output
100.10	100.10
1000.10	1,000.10
10000.10	10,000.10
100000.10	1,00,000.10
1000000.10	10,00,000.10

so on and so forth.

I went through a series of solutions within the community but it did not satisfy my requirement.

Kindly let me know.

[alexnajm]

What solutions have you tried? The TOSTRING function would work like a charm

[binu_acs]

@Kallis as @alexnajm mentioned use the toSTring() function, attaching the alteryx formula 

[Kallis]

Thanks @binu_acs but I still want the datatype to remain numerical. This is what I am unable to. I tried ToNumber and also Select to convert the datatype to any integer but the formatting (. and ,) is removed

[alexnajm]

That’s correct - you cannot do this for numeric data in Alteryx since numbers don’t have formatting. You can change the formatting in your output.