Convert to accounting number format

[Edgar_Ryan_C]

Hi Folks,

How can I convert this formula from Excel into Alteryx function? I need to interchange all the dots and commas.

Thank you.

[echuong1 · Accepted solution]

Try this:

I replaced the periods with a pipe, and then replaced the commas with a period. Once I had that, I could replace the pipes with commas.

I will note that adding commas will turn the value into text, not a number. If you need to do math on these values, you will need to remove the commas. If you want the commas there for presentation purposes, you can turn them on in the user settings. 

[Edgar_Ryan_C]

@echuong1 Worked perfectly. Thank you so much and I appreciate the quick help.