Tom’s Tutorials For Excel: Entering International Currency Symbols

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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,
5 comments on “Tom’s Tutorials For Excel: Entering International Currency Symbols
  1. Lee says:

    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. 😉

  2. shafique ahmed says:

    indian currency symbol???

    • Tom Urtis says:

      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

  3. Ganesh Shanbhag says:

    India Rupee Symbol

    • Tom Urtis says:

      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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*