Skip to main content

Displaying currency formula in a text formula

  • October 15, 2020
  • 1 reply
  • 4 views

Forum|alt.badge.img

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

kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • October 15, 2020

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