Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

'₴' 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?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Google Spreadsheets uses 'грн.' to identify hryvnia. To use the currency Google tells us we need to:

  1. Select the range of cells you'd like to format or modify.
  2. Click the 123 toolbar icon.
  3. Select the number, date, or currency format you'd like to apply to the range of cells.

You can also add Custom Currencies (like ₴) using the 123 menu as in the screenshot below.

enter image description here

Type in the currency you want:

enter image description here

and you will be able to select them:

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.