Skip to main content

Displaying currency formula in a text formula

  • October 15, 2020
  • 1 reply
  • 57 views
S
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!

    This topic has been closed for replies.

    1 reply

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 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.

      Terms & ConditionsAccessibility statement