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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.