cooper collier 6/12/2020 11:42:56 AM
if you are using the same currency for everything, you can change this in the column settings.
Scroll down and look for the Numeric Options.
You use any symbol and decide how it displays.
If however, you have a situation where the column amount represents a different currency for each record. and you wish to display the correct symbol
Wood Screws, US dollars, 100 show $100
Screw Driver , Euros, 50 show 50€
Hammer, japanese yen 100 etc. etc.
Then you will have to make a formula to display it based on currency selected in each record. If you have to do it, you should probably use a Case() formula,