Originally Posted by mytyab
When I try to format the field to currency, nothing happens.
Most likely, there are excess spaces in your column, that prevent the conversion of the column's data to the currency format. If it is the case, then you can use the Trim spaces add-in
to get rid of them.