Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Displaying currency formula in a text formula

Topic Labels: Formulas
2123 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Steven_Joiner
5 - Automation Enthusiast
5 - Automation Enthusiast

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.