How to insert the Naira currency Symbol (₦) in Excel - dbrown Consulting

June 24, 2021

How to insert the Naira currency Symbol (₦) in Excel2 min read

Great technique to permanently program your computer with the Naira Currency (₦) symbol

As an analyst, you should definitely format your reports appropriately to correctly convey information. In order to do this effectively, you will need to learn how to program the naira sign into your computer, so anytime you need it. It appears. To do this, you need to program you currency symbol.

Step 1:

Go to home, you will see the currency Icon, you need the Naira sign here

It is not here currently. You want a setting so that when you click it, it brings the Naira sign. There is a trick to do this. However, it is not an excel thing, it is a windows thing. You need to do this in control panel.

Step 2:

Press the Windows button on your keyboard, type “Region and language”.

Step 3:

Click on Region and a dialog box appears.

Step 4:

In the dialog box, go to Additional settings.

Step 5:

In Additional setting, you will see Number, Currency, Time and Date tabs. Go to Currency.

Step 6:

In Currency symbol section, click on the dropdown and you will see the pound sign and other currency signs. Note: Be sure to have copied the Naira s.g8. ₦), first before you come to this section.

Step 7:

Delete the pound sign and paste the naira sign with CTRL + V.

Step 8:

When you are done, you can now click Apply.

Step 9:

Click OK, then OK again in the next dialogue box.

You have programmed your currency in your control panel. When you come back to excel, you can see it there. It automatically changes to ₦aira.

Step 10:

Highlight the cells you want to format, use the keyboard shortcut (CTRL + SHIFT + 4) or the format command on the Home tab to format.
It shows with Naira sign (₦). When you click the dropdown, you will see other currency symbols there to be used. However, your default has now been set to Naira (₦) sign.

This technique would certainly improve your reporting considerably. It will help your reporting to look far better by representing the Nigeria currency symbol appropriately. Hope this helps you. Ciao

Tip: Let’s get Microsoft to make all the above automatic by changing the default currency for Nigeria from NGN to ₦.

Related Guides

Recent Blogs

About the Author

Bridget Adekoya

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Invest in your career goals

Invest in your career goals

Invest in your career goals

Invest in your career goals

Dbrown Consulting

Invest in your career goals

Invest in your career goals

How to insert the Naira currency Symbol (₦) in Excel2 min read

Great technique to permanently program your computer with the Naira Currency (₦) symbol

Step 1:

Step 2:

Step 3:

Step 4:

Step 5:

Step 6:

Step 7:

Step 8:

Step 9:

Step 10:

Related Guides

Recent Blogs

Subscribe

About the Author

Bridget Adekoya

Connect with us

30.1k

Training

Consulting

Resources

About Us

Basket