|

In Excel, there are multiple number format options.

Among these options is the currency number format.

If you chose this number format, any number in your selection will have a currency symbol beside it (typically on the left side of the number).

For example, when you apply the currency number format to 1015, it will show as \$1,015.00 (depending on your Excel’s default currency symbol).

TIP: Another number format that adds a currency symbol to numbers is the accounting format.

The default currency that Excel uses may vary from user to user.

For example, my Excel’s default currency symbol is \$ (dollars).

So when I apply the currency number format to a number value, it will have the dollar sign (\$) beside it (e.g. from 1 to \$1.00).

Does this mean I cannot add other currency symbols to numbers in my Excel?

The short answer is no. I can still insert other currency symbols that are not the dollar sign (\$).

You can add any currency symbol to numbers in Excel, and there are many ways to go with it.

You can type the currency symbol yourself, explore the currency format options, or even change the default currency symbol.

In this article, we’ll be focusing on how to insert the pound (£) symbol in Excel.

That said, some of the steps here may also apply to other currency symbols such as the peso (₱), yen (¥), rupee (₹), etc.

In addition, we’ll also be discussing how to insert the pound symbol (£) in Google sheets.

Let’s get started.

## Use Keyboard Shortcut to Insert the Pound Symbol (£) in Excel

If you simply want to add the pound symbol to a number, you can just use a keyboard shortcut.

In particular, the keyboard that you’ll have to use is Alt + 0163.

Suppose you have the following dataset:

Column A has a list of items. The price of each item is listed in column B.

You want to add the pound symbol (£) to these numbers.

• Select the cell where you want to insert the pound symbol (£). Double-click on it, or press F2. This will let you edit the value that the cell contains. Position the cursor before the number (on the very left side).

• Press the keyboard shortcut Alt + 0163. To be more specific, press and hold the Alt Then, while holding the Alt key, press 0, then 1, then 6, and finally, 3. Let go of the Alt key.
• The number should now have a pound symbol (£) beside it. Press the Enter key.

• Do the same to the rest of the column.

Things to note

• You can insert only the pound symbol (£) one cell at a time
• If the pound symbol (£) is Excel’s default currency symbol, the currency number format will be automatically applied to the cell. Otherwise, Excel will apply the text format to the cell.
• This method is not ideal for inserting the pound symbol (£) into a group of numbers

## Use the Format Cells Dialog Box to Insert the Pound Symbol (£) in Excel

If you’re looking for a more efficient to insert the pound symbol (£) into a set of numbers in Excel, then it’d be better to format the cells as currency instead.

To do so, we’ll be using the Format Cells dialog box.

You can access this by pressing this little button.

This can be accessed by opening the Home tab.

In the middle section of the ribbon, you will find the Format Cells dialog box launcher tool.

### Insert the pound symbol (£) via the Format Cells dialog box

Let’s work with the same dataset.

This time, you’ll be adding the pound symbol (£) to all the numbers in column B.

• Select the cells where you want to insert the pound symbol (£).

• Open the Format Cells dialog box. To do so, open the Home tab. In the middle section of the ribbon, you will find the Format Cells dialog box launcher tool.

• In this dialog box, open the Number tab. Under category, select Currency.

• On the right side of the box, you should find a dropdown arrow inside the box next to Symbol. Click on it. This will give you a list of currency symbols.

• Select an option that has the pound symbol (£). For example, you can select the £ English (United Kingdom)

• Click the OK button.

• The pound symbol (£) should now be inserted into your selection.

#### Things to note

• This only works with numbers. If the cell has an alphanumeric value, this will method will not work.
• If the pound symbol (£) is Excel’s default currency symbol, then you only have to apply the currency format to your selection.

## Apply the Accounting Number Format to Insert the Pound Symbol (£) in Excel

Another option for mass inserting the pound symbol (£) into a group of data is to apply the accounting format.

Unlike the currency format, the pound symbol (£) will not appear beside the number.

Rather, the pound symbol (£) will appear on the very right of the cell:

To apply the accounting format with the currency symbol, you’ll be using this button:

This can be accessed by opening the Home tab.

In the middle section of the ribbon, you will find the Accounting Number Format button (represented by a dollar sign).

### Insert the pound symbol (£) by applying the Accounting Number Format

Let’s work with the same dataset.

You’ll be adding the pound symbol (£) to all the numbers in column B. Only this time, you’ll be applying accounting number format.

• Select the cells where you want to insert the pound symbol (£).

• Open the Home tab. In the middle section of the ribbon, you will find the Accounting Number Format button (represented by a dollar sign). Click the dropdown arrow next to it. This will present you with several options.

• Among these options, select the £ English (United Kingdom) Click on it.

• You have successfully inserted the pound symbol (£) into your selection.

## Change the Default Currency to the British Pound (£)

If you plan to always use the pound symbol (£), then you may want to change the default currency.

Do note that this method involves changing system settings.

It will change the default currency for all programs that use it.

• Open the Control Panel. You can search for it via the search bar in your toolbar.

• Click on “Change date, time, or number formats” under “Clock and Region”. This will open the Region settings.

• In the pop-up box, click the Additional Settings button.

• In the Customize Format pop-up box, open the Currency tab. Set the Currency symbol to £, then click the Apply or OK button. This should change the default currency symbol to £.

## Insert the Pound Symbol (£) in Google Sheets

Just like in Excel, you can also insert the pound symbol (£) in Google Sheets.

Here’s how you do it.

• Select the cells where you want to insert the pound symbol (£).

• Click on the Number Format button.

• Select and click on Custom Currency among the options.

• In the textbox under Custom currencies, type the pound symbol (£). You can do this by pressing the keyboard shortcut Alt + 0163. Click the Apply button after doing so.

• You have successfully inserted the pound symbol into your selection.

## Conclusion

And those are the methods you can use to insert the pound symbol (£) in Excel and Google Sheets.

I hope that you’re able to use your learning here in your future endeavors.