Hello,
Is their a way to format the Money field type to always show its value in a typical currency format like, $1,000,000.00? Currently this field type only shows 1000000.00 format. I can add a UoM symbol of $ to the field but this shows as 1000000.00 ($). Neither of these formats are very acceptable and are very hard to read, especially when dealing with large values. I've tried to use the Regular Expression Input Mask but that doesn't seem to be appropriate use as it has no impact on the format.
I've included an image file for reference.
Thank you,
John
Hi John,
This is correct, currently our money field doesn't have the ability to separate with commas.
In order for you to utilize the comma, you will need to utilize single line text - example image.
However by using the single line text, you will lose the functionality of the precision.
I would recommend you to submit this to the Idea Station.
thanks,
Trung