How to Insert the Cent Symbol in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on April 3, 2023

This tutorial demonstrates how to insert the cent symbol in Excel and Google Sheets.


insert cent symbol 11


Insert Cent Symbol

You can insert a cent sign from Symbols, but with this method, you are able to insert a symbol in one cell at a time. After that, you can copy the symbol to the rest of the range. (You can automate this insertion with the VBA loop).

Say you have the following data with the product names in Column A and the product prices in Column B.


insert cent symbol 1


To format the numbers in Column B as amounts in cents, follow these steps:

  1. Select the cell where you want to insert the cent sign (e.g., B2) and in the Ribbon go to Insert > Symbol.


insert cent symbol 5


  1. In the Symbol window, select the Latin-1 Supplement from the Subset drop-down menu.
    Then choose the Cent Sign ¢, click on Insert, and Cancel.


insert cent symbol 3


The cent symbol is now at the end of cell B2.


insert cent symbol 6


Custom Number Format

The easiest way to insert the cent sign to multiple cells at once is to use a custom number format.

  1. To open the Format Cells window, select the range where you want to insert a cent symbol.
    In the Ribbon go to Home, and click on the Number Format icon in the lower-right corner.


insert cent symbol 7


Or select the range where you want to insert a cent sign, right-click it and from the list choose Format Cells…


insert cent symbol 8


  1. This opens the Format Cells window. In it, click on the Number section and in the category list, click on Custom.
    In the Type box, enter (press ALT + 0162 or copy the cent symbol). Click OK.


insert cent symbol 9


As a result, the cent sign is added to the selected cells.


insert cent symbol 10


Cent Symbol Alt Code

You can enter special characters by typing in their shortcut code. To insert the cent symbol with this method, hold down the ALT key and enter 0162.

Cent Sign in Google Sheets

In Google Sheets, you can also insert a cent sign by formatting cells as currency.

  1. Select the range where you want to insert a cent sign (B1:B6), then click on the More Formats icon (123) in the toolbar, select More Formats, and choose Custom number format.


insert cent symbol 12


  1. In the Custom number formats window enter (press ALT + 0162, or copy the cent symbol). Click Apply.


insert cent symbol 13


As a result, the cent sign is added to the cells.


insert cent symbol 14

AI Formula Generator

Try for Free

See all How-To Articles