Displaying currency formula in a text formula

I am including a currency field in a text formula. How do I get the string to show the currency formatted properly?

Example: The currency formula field shows: $116.67, but when I include that field in a text string it shows up as 116.66666666666667. Of course, I’d like to look as it does in the currency formula.

Thanks for any help!

Welcome back to the Airtable community!

This is a long-standing difficulty. I recommend you check out the “Pretty Print” info in this thread.

1 Like