Insert Currency Symbols & Other Special Characters in Excel [Quick Tip]
Posted on October 11th, 2010 in Excel Howtos  17 comments
Often, we need to input special symbols like €£¥©½» in to our Excel sheets. Now, how do we do that?
Simple, you can use Insert > Symbol to add several different kinds of symbols.
See this animation to understand how you can add symbols to an excel cell. (the file is kind of big, so give it a few seconds to load)
5 Bonus tips on using Symbols:
 You can just double click on the character to insert it. No need to press Insert button.
 You can quickly open insert symbol dialog by pressing ALT+I and then S. (related: 97 keyboard shortcuts to boost your excel mojo)
 You can use the symbols in formulas too. For eg. you can show ? or ? or ? based on change of one value wrt to another. Like this:
 =if(A1>A2, “↑”, if(A1<A2,”↓”,”↔”)) (related: incell charts)
 Quickly access symbols to specific to currency, arrows or greek chars (if you are in to that sort of thing) by using the dropdown at topright (see above demo).
 Change the font to Wingdings / Webdings to see some useful and fun characters. You can spice dashboards or reports with these.
Symbols & Excel – See this stuff:
 Making Chart Legends better with Symbols
 Incell Dot Plots with Symbols & Formulas
 Use Spot Matrix Charts when comparing values
 Best Cities to find job – incell dashboard using symbols
 Displaying Symbols in Excel Chart Axis
 
 

Leave a Reply
Finding 2nd Largest Item in a List that meets a Criteria [Excel Array Formulas]  Financial Modeling School Coming on Monday [Details Inside] 
17 Responses to “Insert Currency Symbols & Other Special Characters in Excel [Quick Tip]”
I preach this sometimes:
use a named range for your symbol. IE: =if(a2<b2,down,up) where down contains your down arrow and up contains your up arrow.
Very good illustration. What program did you use to create that gif file?
@Gregory: Thanks. I use camtasia screenrecorder to record and produce output as animated GIF shown above. You can get a trial version here: http://techsmith.com/
@Dan: Good idea. Even I use the same method as arrow symbols get referred alot.
That’s what I use, but your stuff looks much better. Hmm…
Hi Chandoo,
First of all – thank you very much for setting up this site with a minefull of excel usables. Your blogs have become my reference these days.
India has adopted a new symbol for Rupee, is there a way we can insert this in MS applicatons (particularly Excel). Currently I do this by changing the font to “Rupee Foradian” individually. I was looking for a shortcut which i can make in excel and insert while writing – something like remapping a key which is not used.
Cheers
When entered = sign, to enter a formula in excel, then all menus in the insert menu become inactive, thus i can’t use symbols in formula. pls help me. thanks
@Umoru
Instead of using = , in a blank cell just go straight to the Insert menu and enter your symbol in the cell
Now you can edit the cell F2 select the symbol, Copy/Paste where you want it.
Hi Chandoo:
I’m using Excel 2007. How do I insert symbols into excel 2007 formulas? I’ve scoured the site and haven’t found an answer that works yet. Thanks.
You have a few options
1. Use a Formula like: =IF(A2>5,”a”,”?”) the character has been entered as a symbol in another cell and then copied into the formula
2. You can use the =Char() function like: =IF(A2>5,”o”,char(210)).
In either of the above cases you can set the font of the cell to match what character set you want to use.
That is a formula like =IF(A2>5,”A”,”B”), when the cell is set to wingdings will show the relevent characters from the Wingding font namely an Ok and a Thumbs Up hand sign
Hi Chandoo,
First of all, I want to thank you for your website. This is such a great resource! I learn from it daily!
I love your posts on Conditional Formatting and Incell Charts with instructions for great data visualizaiton ideas. Most definitely my boss would be in awe if I could do this. However, I can’t make the informula symbols work. I have tried all suggestions from this discussion thread, but still can’t make it work. I started thinking that it might not work because I use Excel 2010. Please advise. Thank you!
@Innaya
Which symbol/technique doesn’t work in 2010?
@Innaya
Down and Up must refer to either a Named Range which has a character in it you want or they can be refer to a single Character like: 5 and 6
.
Following up as per your email, but so others can also see what the solutions may be
.
1. If you use a formula like =if(a2
Then change the Text Font of the cell with the =if(a2
2. Goto a Blank Ce3ll, Insert Symbols, Find a symbol and Insert it, remember the font it came from
F2, copy the symbol and paste it where you want it
F2 on the new location and select the individual character, Change the font to what it was before in Insert Symbol
.
3. Goto a Blank Column
In Row 1 type =Char(Row())
Copy down to Row 255
look up/down to see what character you are after and make note of the Row No. (lets assume row 106)
Then use =Char(106) you should get a small j
.
You can also select the whole column and Change the Font to say Web Ding, Wing Dings 1, 2 or 3 and see what different characters are available
Hello,
I spend a lot of time on this blog learning but I still cannot figure out how to insert the symbol into the excel formula, and without changing the font to Wingdings, have the actual symbol appear in the formula (like the actual arrow appear in quotation marks in the formula). Any advice?
Thanks!
@Amy
This can be confusing at timesCan you post a sample of the formula you are trying to use?
Can you post a sample of what output you expect?
The article describes how to create currency pair (Forex) icons using country flag images for use with an Excel Ribbon Gallery. Only elementary graphics design skills are required.
See more at:
http://www.spreadsheet1.com/forexiconsinanexcelribbongallery.html
i wana know how we insert Special Characters In cell which already have another formula (exp. cellNo. C10 have formula =A10+B10, and ans. is 10, but i want display in cell C10 *10
hi chandoo! this is a really nice site. wish i found this sooner.
can you pls help me with this: i’m tying to put these symbols èéê (in windings) in my formula. here’s the sample formula =IF(B7>B6,B7&” é”,IF(B7<B6,B7&" ê",B7&" è"))
the output should be a number together with the arrow sign.
but how do i make it appear as such? instead of the arrow signs what appears are these èéê
i've tried entering the formula without the = sign so that i can change the font to windings for specifically for these (èéê) only but when i put the = sign it reverts back to being letters instead of the arrow signs. thanks!