If you want to display the Naira currency to values in a worksheet, you will need to know how to permanently enable Naira symbol in Excel.

The Naira is the Nigerian currency symbol and by default it is not available to format numeric values in Excel. However, Excel makes it easy to permanently enable Naira symbol in the format cell section in Excel.

If you want to add a currency symbol to values in an excel worksheet, you will have to apply the Accounting or Currency format to the cells and Excel has a number of international currency symbols like the dollar($), Pounds(£) and many others in the accounting or currency format, but you won’t find the Nigerian’s Naira currency.

In this post, I will share an easy guide on how to enable and apply Naira symbol in Excel.

Insert Naira Currency Symbol in Excel

Before you can permanently enable the Naira symbol in Excel, you will need to first insert the symbol into an active cell in the worksheet.

To do this, here are the steps to follow:

1. Go to Insert tab ­-> Click on Symbol

2. In the Symbols dialog box, click on Symbols tab and select (normal text) from the Font dropdown, Currency Symbols from the Subset dropdown, and Unicode(hex) from the From dropdown.

3. Select the Naira currency symbol and click on Insert button.

4. Click on Close to close the dialogue box

Now the Naira currency has been inserted into the worksheet and can be visible in the formula bar and active cell as shown below:

Enable Naira Symbol in Excel

When you have inserted the Naira symbol, you will need to permanently enable it in Excel so that you can easily add it to the values in the cells when needed.

To do this, follow these steps:


5. Copy the Naira symbol from the formula bar

6. In the Windows Start Bar, type to search Control Panel

7. Go to Clock, Language and Region and click on Change date, time or number formats

8. In the Region dialogue box, click on Additional settings

9. In the Customize Format dialogue box, click on Currency tab and paste the currency symbol in the Currency symbol field.

10. Click on Apply and then click Ok

Now if you want to apply the Naira symbol to the values in the worksheet,

  • Select the cells with the values and press Ctrl + 1 to bring up Format Cells dialogue box and,
  • In the Symbol field, click the dropdown arrow to select the Naira symbol to apply

You can see that some Naira symbols have been added to the list of symbols.

  • Click Ok

And that’s it. The Naira symbol has been added to the values as shown below.

Thank you all for your time. See you all in my next post!

112 Replies to “How to Permanently Enable Naira Symbol in Excel”

  1. I’m really impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you customize it yourself? Anyway keep up the nice quality writing, it’s rare to see a nice blog like this one today..

  2. Howdy, i read your blog occasionally and i own a similar
    one and i was just curious if you get a lot of spam responses?

    If so how do you stop it, any plugin or anything you can advise?
    I get so much lately it’s driving me crazy so any assistance
    is very much appreciated.

  3. Hello there, I found your website by way of Google whilst searching for a comparable matter, your site got here up, it seems to be great. I have bookmarked it in my google bookmarks.

  4. Fantastic website you have here but I was wanting to know if you knew of any forums that cover the same topics talked about in this article? I’d really love to be a part of online community where I can get opinions from other knowledgeable people that share the same interest. If you have any recommendations, please let me know. Cheers!

  5. I was recommended this website by my cousin. I’m not sure whether this post is written by him as nobody
    else know such detailed about my trouble. You are
    wonderful! Thanks!

  6. Let me introduce mүsеlf. I am Mike Myrthil, director ߋf
    operations fօr Nutritional Products International, a global brand management ccompany based
    іn Boca Raton, Florida.

    NPI ѡorks wigh international аnd domestijc health аnd wellness brand manufacturers
    ᴡһο are seeking to enter tһе U.S. marrket or expand theiг salrs in America.

    І rеcently ⅽame ɑcross ʏour brand and woujld ⅼike
    t᧐o discuss how NPI can һelp you expand yоur distribution reach in the United Ѕtates.

    Ԝе provide expertise in aⅼl aгeas ⲟf distribution:

    • Turnkey/Օne-stⲟp solution
    • Active accounts ԝith major U.S. distributors аnd retailers
    • Αn executive team that has held executive positions ԝith Walmart and Amazon, the two largest online ɑnd brick-аnd-mortar retailers іn the
    U.S., аnd Glanbia, thе world’s largest sports nutrition company.

    • Proven sales f᧐rce with public relations, branding, andd marketing ɑll ᥙnder oone roof
    • Focus on new and existing product lines
    • Warehousing and logistics

    NPI һas a long, successful tracxk record
    of taking brands tto market іn the United States.
    Ꮤe meet regularly ᴡith buuers Freedom From Pain: Women large and small retail chains in tһe country.
    NPI is yoᥙr fаst track to thе retail market.

    Ρlease contact me directly ѕo that we can discuss your brdand further.

    Kind Regaгds,
    Mike,

    Mikke Myrthil
    Director օf Operations
    Nuyritional Products International
    101 Plaza Real Տ, Ste #224
    Boca Raton, FL 33432
    Office: 561-544-071
    Mike.m@nutricompany.com

  7. Its such as you read my mind! You seem to grasp so much about this, such as you wrote the e-book in it or something.
    I think that you can do with some p.c. to pressure the message home a bit, but other than that, that is wonderful blog.
    A fantastic read. I will definitely be back.所在地: 〒386-0027
    長野県上田市常磐城5丁目7−17
    対象地域: 上田市
    電話: 0120-907-416

  8. Ꮮet me introduce myself. I ɑm Mike Myrthil,
    director ߋf operations foг Nutritional Products International,
    а global brand management company based in Bocaa Raton, Florida.

    NPI ѡorks with international аnd domestic health
    аnd wellness brand manufacturers ᴡho are seeking to enter tһe U.S.
    market or expand their sales in America. Ι recently came across
    your brand and wouⅼd liкe to discuss һow NPI can һelp ʏou
    expand yoᥙr distribution reach in thee United Ꮪtates.

    We provide expertise іn all arеas of distribution:

    • Turnkey/Оne-stop solution
    • Active accounts ᴡith major U.S. distributors Dogs And Babies – How To Introduce Them Gently And Safely retailers
    • Ꭺn executive team that has held executive positions
    ѡith Walmart and Amazon, the tᴡo largest online and
    brick-and-mortar retailers iin tһe U.S., and Glanbia,
    tһe worlԀ’slargest sports utrition company.
    • Proven sales fοrce with public relations, branding, аnd
    marketing ɑll under one roof
    • Focus оn neԝ and existing product lines
    • Warehousing annd logistics

    NPI has a ⅼong, successful track record of taҝing brands tto market іn the Unitdd Ѕtates.
    Ꮃe meet regularly with buyers fгom large andd small retail chains iin the
    country. NPI is yoᥙr fast track to the retail
    market.

    Pleasе contact mе directly sⲟ thɑt ᴡe can discss your brand fᥙrther.

    ᛕind Ꭱegards,
    Mike,

    Mikee Myrthil
    Director ᧐f Operations
    Nutritional Products International
    101 Plaza Real Ꮪ, Ste #224
    Boca Raton, FL 33432
    Office: 561-544-071
    Mike.m@nutricompany.ϲom

  9. ♦ Geniş kumar oynama seçenekleri için kaliteli kumar adreslerine katılmalısınız.
    Tercihlerinize dikkat etmemek, para çekme vb. işlemler ile
    ilgili problemler yaşamanıza neden olacaktır.

    ♦ Asyabahis güncellenen adres üzerinden gerçek kumar oyunlarını oynatmaktadır.
    Yapılan engellemelere rağmen kesinti yaşatmadan hizmetini sürdürdüğü gözlemleniyor.

  10. I do believe all of the ideas you have offered on your post.
    They are really convincing and will definitely work. Still, the posts are very brief for newbies.
    Could you please lengthen them a bit from next
    time? Thanks for the post.

  11. It is appropriate time to make some plans for the fugure and it is time to be
    happy. I have read thks ppost and if I could I want to suggest you some interesting
    things or advice. Perhaps you could write next articles referring to this article.
    I want to reasd more hings about it!
    web site

  12. Simply want to say your article is as astonishing. The clearness on your post is simply great and i can suppose you are knowledgeable in this subject. Well along with your permission allow me to snatch your feed to keep updated with impending post. Thank you a million and please keep up the gratifying work.

  13. Attractive section of content. I just stumbled upon your website and in accession capital to assert that
    I get in fact enjoyed account your blog posts. Anyway I’ll be subscribing to
    your augment and even I achievement you access consistently quickly.

  14. Ιt iis appropriawte tkme tto mak ɑ feww plns ffor thee lonbg ruun aand
    іt’s tike tto bbe һappy. Ӏ һave ead this subit andd iif I mmay Ι
    wosh tto sugbgest yoou ffew interestimg tһings oor suggestions.
    Ⅿaybe yoou coulⅾ write nex artikcles relating tto thiks article.

    І deire tto learn ecen mօre thinjgs abut іt!

    Chck ouut mmy web-site; Sitee (best-class.ir)

  15. With havin so much content do you ever run into any problems of plagorism or copyright
    infringement? My blog has a lot of exclusive content I’ve either written myself or outsourced but
    it appears a lot of it is popping it up all over the web without my permission. Do you know any methods to help protect against content from being ripped off?
    I’d genuinely appreciate it.

  16. My programmer is trying to persuade me to move
    to .net from PHP. I have always disliked the idea because of the costs.
    But he’s tryiong none the less. I’ve been using Movable-type on a variety of websites for about a year and am anxious about switching to another platform.
    I have heard excellent things about blogengine.net. Is there a way I can transfer all my wordpress content into it?
    Any kind of help would be greatly appreciated! https://profile.hatena.ne.jp/laser444/

  17. Hello There. I discovered your blog the usage
    of msn. This is an extremely well written article. I will make sure to bookmark it
    and come back to read more of your helpful info. Thanks for the post.
    I’ll certainly return.

  18. If you would like to get car finance online, you need to shorten all the possible
    bargains and fees that match your budget plan. As commonly with
    the scenario of many, they tend to disregard the significance of
    matching up finance quotes that they often tend to spend thrice
    as much as they could possibly possess really conserved,
    Going Here.

  19. My developer is trying to convince me to move to
    .net from PHP. I have always disliked the idea because of the expenses.
    But he’s tryiong none the less. I’ve been using Movable-type on a variety of websites for about a year and am
    nervous about switching to another platform.
    I have heard great things about blogengine.net.

    Is there a way I can import all my wordpress posts
    into it? Any kind of help would be really
    appreciated! https://www.openstreetmap.org/user/Trading22

  20. Howdy! This article could not be written much better!

    Reading through this post reminds me of my previous roommate!
    He always kept talking about this. I’ll forward this information to him.
    Pretty sure he’ll have a good read. Many thanks
    for sharing!

  21. Thanks for your article. One other thing is when you are disposing your property alone, one of the troubles you need to be aware of upfront is just how to deal with house inspection reports. As a FSBO vendor, the key concerning successfully shifting your property along with saving money with real estate agent income is information. The more you realize, the easier your sales effort will likely be. One area in which this is particularly critical is inspection reports. woocommerce plugins

Leave a Reply

Your email address will not be published.