Search

# 3 Easy Ways to Insert Cent Symbol in Excel

If you work with currency/sales data, it comes in handy to know how to insert dollar and cent symbols with the numerical/sales values in Excel.

While the dollar sign is right there on the keyboard, cent symbol is a little more difficult to find and insert.

How to Insert Cent Symbol in Excel

## How to Insert a Cent Symbol in Excel

In this tutorial, I’ll show you three different ways to insert the Cent symbol in Excel:

1. Using a Keyboard Shortcut.
2. Using the CHAR function.
3. Using Auto-correct feature.

Let’s begin.

### Using a Keyboard Shortcut

The keyboard shortcut to insert the cent symbol in Excel is:

`ALT + 0162`

You need to hold the ALT key and then press 0162 on the number keypad of your keyboard. As soon as you this and leave the ALT key, you see that the cent symbol has been inserted.

### Using the CHAR Function

You can use the Excel CHAR function to insert the cent symbol in a cell in Excel.

To do this, enter =CHAR(162) in a cell and press enter. It will automatically return the cent symbol as the result.

You can also use this formula with other text strings or formulas to add the cent symbol to it.

For example, if you want to have 10¢ in a cell, you can use the formula =10&CHAR(162).

`Also read: Insert Pi Symbol (π) in Excel`

### Using the Autocorrect Feature

Excel autocorrect feature enables you to assign a text code to the cent symbol (let’s say CENTSYM).

Now, whenever you enter this code CENTSYM in any cell in Excel, it will automatically convert it into the cent symbol.

Here is how to do this:

• Go to File –> Options.
• In the Options dialogue box, select Proofing –> Autocorrect Options..
• In the Autocorrect dialogue box, enter the following:
• Replace: CENTSYM
• With: ¢ (you can get the cent symbol by using the shortcut ALT 0162, the =CHAR(162) function, or simply copy-paste it from this tutorial).
• Click Add and then OK.

That’s it! Now, whenever you type the text CENTSYM, it will automatically get converted into the cent symbol.

NOTE:

• The autocorrect feature is case-sensitive. Hence, if you enter centsym, it will not get converted to the cent symbol. You need to enter CENTSYM for this to work.
• This change also gets applied to all the other Microsoft applications (MS Word, MS PowerPoint, etc.). So be cautious and choose the keyword that you are highly unlikely to use in any other application.
`See Also: Use Autocorrect in Excel to Save Time.`

So, these are the three methods you can use to type the Cent symbol in Excel. If you come across any other method, do share it with me in the comments section.

How did you like this tutorial? Let me know your thoughts by leaving a comment below.

You May Also Like the Following Excel Tutorials:

FREE EXCEL BOOK

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.