How to add Indian Rupee Currency symbol in Google Spreadsheet

Question

I need to add Indian Rupee Currency Symbol Indian Rupee in Google Spreadsheet?

I tried with the following

As you can notice there is NO Indian Rupee symbol. How I can apply this?

Thanks in advance

Answer 1

To apply a custom currency format to your spreadsheet:

1. On your computer, open a spreadsheet in Google Sheets.
2. Highlight the data you want to format.
3. Click Format. Number.
4. Click Custom currency.
5. Search in the menu text box to select a format. You can also add your own custom currency format into the text box.
6. Click Apply.