'₴' 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 Sheets – Use Specific Currency Symbol in Google Spreadsheets
google sheetsgoogle-sheets-cell-formatunicode
Related Topic
- Google-sheets – Notes In Published Google Spreadsheets
- Google Sheets Conditional Formatting – Format Range Based on Other Cell Values
- Google Apps Script – Copy Column with Mixed Currencies
- Google Sheets – Left Align Dollar Symbol and Right Align Number
- Google Sheets – How to Remove Insignificant Decimal Points
- Google-sheets – Dynamic updating referenced cell from another workbook after adding/deleting rows using IMPORTRANGE – use ARRAY or VLOOKUP
- Google Sheets – Convert Currency to USD Based on Currency Shown in Cell
Best Answer
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: