Change currency format

SERGIO BARRETO

Hi, I want to change the format to Colombian pesos, in the list is available the currency, but in the column the system adds the label “COP” instead of the peso symbol “$”. How do I replace the "COP" with the “$” symbol?

Jamie Anderson-Oracle

Please forgive me if this is a naive workaround, but would it be possible to use the $USD/$ notation in your use case?

I tried mocking up an example (and changing the titles of each table to show which Currency/Moneda formatting I used, and I don't think there is any way for the workbook consumer (end-user) to know that the behind-the-scenes currency format is not actually COP. However, if this is not the case, please let me know!

Editing to add: Note that the platform is not "translating" the currency when you toggle the currency formatting options, otherwise this suggestion would obviously not work!