Retain "Thousands format" when concatenating cells

Hello,

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.


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!