Tom’s Tutorials For Excel: Entering International Currency Symbols
While it’s true that you can insert currency symbols from the Symbol dialog box into your cell’s text, it’s faster and easier to produce those symbols by using the keyboard as you are typing your text.
Here are four examples to show how you can use the keyboard to enter currency symbols in your non-numeric text entries. Each sentence is a little different but you’ll quickly get the idea.
Example 1 text for the United States Dollar symbol:
The currency symbol for the United States Dollar is $.
You enter (without the square brackets):
The currency symbol for the United States Dollar is [Alt+0036].
Example 2 text for the European Union Euro symbol:
€ is the European Union's Euro currency symbol.
You enter (without the square brackets):
[Alt+0128] is the European Union's Euro currency symbol.
Example 3 text for the British Pound symbol:
The currency symbol £ represents the British Pound.
You enter (without the square brackets):
The currency symbol [Alt+0163] represents the British Pound.
Example 4 text for the Japanese Yen symbol:
My California home would cost ¥70,968,965 in Japan.
You enter (without the square brackets):
My California home would cost [Alt+0165] 70,968,965 in Japan.
You know, we Brits still feel mildly indignant when we remember that you don’t have the sterling symbol on your keyboards, when ours have £ and $ sat proudly side by side. 😉
indian currency symbol???
Custom formats:
Rupees with Paise
[>9999999]”Rs.”##\,##\,##\,##0.00;[>99999]”Rs.”##\,##\,##0.00;”Rs.”##,##0
Rupees without Paise
[>9999999]”Rs.”##\,##\,##\,##0;[>99999]”Rs.”##\,##\,##0;”Rs.”##,##0
Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]”##\,##\,##0.00;”##,##0.00
India Rupee Symbol
For the cell you want a Rupee symbol, select that cell and press Ctrl+1 to open the Format Cells dialog box. On the Number tab in the Category list select Currency. From the Symbol drop-down list select English (India) and click OK.