ADDING a new CURRENCY in NUMBERS

Apple has different lists of currencies for different regions. Why? I don't know. You have to change the region of the spreadsheet to add other currencies to the list.

1. File->Advanced->Language & Region
2. The default will be something like System-English (whatever language your computer is set to)
3. Change the language to be just the language (English for me)
4. Change the region to be Colombia
5. Format at least one cell as Columbian Peso. In the Columbia region it will show it as a $ symbol.
6. Set the spreadsheet back to System-Your_language if you want it like it was. The $ will change to COP.
7. As long as you have at least one cell with Columbian Peso, it will be on the list of currencies (all the way at the bottom). If you delete them all, it will no longer be in the list.

Strange that it would not have the local currency on the list and that this is not working for you. I set mine to Spanish and Colombia and it puts Colombian Peso at the bottom of the list. When I format a cell as currency, it is the default choice.

Go back to the region setting and see if it is Colombia.