This post inspired me to make this product suggestion. We already have the DATETIME_FORMAT function, which lets us use a formula field to reformat the data from a date-type field into a text string of our specifications. But it would be really great to have that exact same ability to reformat a number field or a currency field into a text string of our specifications. For example, take these 2 fields: Currency Field — formatted as currency with $ sign and precision of 2 decimal points Number Field — formatted as decimal with precision of 4 decimal points If we put these 2 fields into a formula that results in anything other than a single number result, they lose all of their formatting. So instead of a desired sentence which looks something like this: “You bought 0.4500 pounds at $2,200 each.” The formula currently looks like this: “You bought 0.45 pounds at 2200 each.” We can easily add in the dollar sign, but adding in the commas and trailing zeros is harder to do in a calculation.
... View more