Help

The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

Displaying currency formula in a text formula

Topic Labels: Formulas
1783 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Steven_Joiner
5 - Automation Enthusiast
5 - Automation Enthusiast
See Solution in Thread

‎Oct 15, 2020 03:04 PM

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!

Reply
1 Reply 1
kuovonne
18 - Pluto
18 - Pluto
See Solution in Thread

‎Oct 15, 2020 04:45 PM

Welcome back to the Airtable community!

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

Reply
Copyright © 2024 Khoros, LLC