Due to the small number of available currencies for currency columns, I’ve been using the FormatCurrency() formula instead. I know it’s an experimental formula, but it had not caused any problem.
But the formula now only recognizes “USD“ and putting any other currency code in it results in error.
Anyone else having the same problem?
I am facing the same issue.
to quote @Eric_Koleda from another source last week
“… I checked with the team and this was intentional. They are reworking those formulas, with plans to launch them officially, and changing it to text was part of that and not a bug.
Use experimental formulas at your own risk!“
hope this helps!
cheers!
Mel
Thanks @Melanie_Teh
To workaround that, I am creating two columns, one is the number itself and the other is the formatted one. I am using a currency table with the codes and the symbols. So the formatting is simple (using format())
Cheers,
Arnhold
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.