There is no situation I can think of were our team needs the currency prefix (e.g., ‘U$’)
This is causing problems when we export it to CSV since it’s effectively a text field and not treated as a number in Excel
Is there a way to turn this off, in both table/list view and in export?
(The team in charge of the accounts prefer the comma-separated thousands, though)
If you don’t want to see the $ sign in your views in the workspace, then I guess you can convert the field from Money to Number.
Unfortunately, the CSV export has no option to toggle the currency prefix on/off.
If you don’t want to remove the Money formatting from your field, then as a workaround, you could add a formula field which simply displays the value (without the money) and then use this column in the views which will be used for export to CSV.