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

How to program the Naira currency symbol (₦) in Excel3 min read

Let’s learn how to program the Naira symbol.
How to program the Naira currency symbol (₦) in Excel

Praise was working on a sales report that was due for presentation to management the next day, she had earlier used Excel’s Number Formatting to change the Sales Figures to a Currency Format. However, Excel’s defaults currency format is not in Naira(), and management wants to see sales in Naira ().

There are several situations we encounter when working in Excel that require us to represent figures in Naira (), this article would teach you an easy way to program Excel and your computer to format the default currency as the Naira (), rather than representing the Naira symbol with NGN or using a double strikethrough on the “N” alphabet then copying and pasting repeatedly.

Note: Using the double strikethrough only works in Microsoft Word, this option cannot be found in Excel, Excel only has the option of a single strikethrough.

Let’s learn how to program the Naira symbol.

Step 1:

First, you must have Excel workbook

Step 2:

Go to the Insert Tab (We are using Excel 2016)

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

Click on the symbol command.

Step 4:

Symbol Dialogue box comes up.

Step 5:

Change your font to Arial. We select the Arial Font here because there are some font types that do not contain the Naira symbol

Step 6:

Go to the bottom of the Symbols dialogue box, ensure Unicode (hex), is selected from the drop down.

Step 7:

Then go to the subset dropdown at the top right corner, click on the dropdown and select Currency Symbols

Step 8:

Once you select the Currency Symbols, the Naira sign should now be displayed.

Step 9:

Select the Naira Sign

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

Then click on Insert, then Close. The Naira Symbol would be inserted into a cell

Step 11:

Now we have got the Naira Symbol. It does not end there; for us to be efficient with Excel we need to automate the process.

Note: you can automate in Excel without the use of VBA codes

Step 12:

The goal here is to automate the Naira symbol into Excel so that, whenever we type NGN Excel would automatically convert it to the Naira symbol.

Step 13:

Now go to the formula bar, highlight and copy the Naira symbol your early inserted and copy it. (Ctrl+C)

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

Go to the File Tab

Step 15:

Click on Options, (you can use the Shortcut ALT + T + O)

Step 16:

Under Excel option, go to Proofing;

Step 17:

Select AutoCorrect options

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

Click ok

Step 19:

Go to Replace and type NGN

Step 20:

Now we want to replace it with the Naira symbol so paste the Naira symbol we earlier copied. (Ctrl V)

Step 21:

Click on Add, to add to your auto correct

excel tutorial naira symbol
Step 22:

Click ok, then ok again

Note: whatever we do in the Excel option affect all the office suites (Word, PowerPoint etc.)

Step 22:

Now we have successfully programed Excel to replace NGN with the Naira symbol

Step 22:

Now anytime we require the Naira symbol just type NGN (press Enter or Space) and Excel automatically replaces it with the 

Step 22:

You can also program Excel to any currency of your choice.

Now you can go ahead and try it Yourself.

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.