Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Displaying currency formula in a text formula

Topic Labels: Formulas
806 1
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

Welcome back to the Airtable community!

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