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!