I’m wondering if there is a way to append the letter M to a currency field. The field in question is a formula based on 2 other fields and the output is a number to 1 decimal point -
##.#, I’d like to format it in such a way that the letter M is appended to it since we know that all the values will be in the millions.
Is that possible? Same question for just standard currency format fields, where the user just enter something like 1.2, and it formats it as $1.2M.
Can either or both of those be done?
Thanks in advance for posting your question! When someone provides an answer, mark their reply as the solution to your topic.