How to insert the Naira currency Symbol (₦) in Excel - dbrownconsulting
    • Invest in your career goals

      Read our latest blogs on Data Driven Decisions made easy

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

Great technique to permanently program your computer with the Naira Currency (₦) symbol
How to program the Naira currency symbol (₦) in Excel

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.

How to program the Naira currency symbol (₦) in Excel
Step 1:

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

How to program the Naira currency symbol (₦) in Excel

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

How to program the Naira currency symbol (₦) in Excel

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 3:

Click on Region and a dialog box appears.

Step 4:

In the dialog box, go to Additional settings.

How to program the Naira currency symbol (₦) in Excel
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.

How to program the Naira currency symbol (₦) in Excel
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.

How to program the Naira currency symbol (₦) in Excel

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

Subscribe

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.