'₴' is a currency sign used for the Ukrainian Hryvnia. It's in Unicode since 2004. I want to use it in spreadsheets as a sign for money values, but Google Spreadsheets doesn't understand it as a number if I add it after or before my value in the cell. How do I make Google Spreadsheets understand it's currency and display it as a number in my desired format?
Google Spreadsheets uses 'грн.' to identify hryvnia. To use the currency Google tells us we need to:
You can also add Custom Currencies (like ₴) using the 123 menu as in the screenshot below.
Type in the currency you want:
and you will be able to select them: