Format the numbers before writing

Question

Hello Everyone

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

InputExpected Output  100.10100.101000.101,000.1010000.1010,000.10100000.101,00,000.101000000.1010,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 · Answer

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.

Kallis · Answer

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

binu_acs · Answer

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