Retain "Thousands format" when concatenating cells



I have two cells, "Amount Requested (local)" and "Local Currency Type" that I want to be concatenated in a single cell. I want the amount requested to retain the "," that is added by using "thousands" formatting

Here is my current formula, is there anything I can change it to so that it spits out "980,425 Euro" instead of "980425 Euro"? Applying thousands format to my new formula column doesn't work.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!