See all How-To Articles

How to Type a Bitcoin Symbol in Excel & Google Sheets

This tutorial demonstrates how to type a bitcoin symbol in Excel and Google Sheets.

 

type bitcoin symbol 4

 

In Excel, you can add a bitcoin symbol by using the currency number format or by inserting a symbol.

Insert the Bitcoin Symbol

Currency Number Format

Say you have the following data set with Product Name in Column B and Product Price in Column C.

 

type bitcoin symbol 1

 

To format numbers in Column C as bitcoins, follow these steps:

1. Select the cells with numbers you want to format as currencies (in this example C2:C8). In the Ribbon, go to Home and click on the Number Format icon in the bottom right corner of the Number group.

 

type bitcoin symbol 2

 

2. In the Format Cells window (1) click on Number and (2) choose the Currency from the drop-down list. In the menu on the right side, (3) click on the arrow to display a drop-down list for Symbol, and from the list (4) select ₿ bitcoin (₿ 123). When done, click OK.

 

type bitcoin symbol 3

 

As a result, all numbers are formatted as currencies with a bitcoin symbol.

 

type bitcoin symbol 4

 

Insert Bitcoin Sign as Symbol

You can also insert a bitcoin sign by inserting it from Symbols. If you go with this method, you can only insert a symbol in one cell at a time, then copy the symbol to the rest of the cells in the range. (If you do this often, you might want to automate the insertion with a VBA loop.)

1. Double-click a cell where you want to add a bitcoin symbol. In the Ribbon, go to Insert > Symbols.

 

type bitcoin symbol 5

 

Note: If you just select the cell and then insert a symbol it will add it at the end of the cell’s value (in this example 70₿). To insert it in front of a number, double-click the cell to position the cursor before a number.

2. In the Symbol window (1) choose Currency Symbols and then (2) select the bitcoin symbol. When done, press (3) the Insert button and (4) Cancel.

 

type bitcoin symbol 6

 

As a result, the bitcoin symbol is in the selected cell.

 

type bitcoin symbol 7

 

Insert Symbol in Google Sheets

Unfortunately, Google Sheets doesn’t offer a way to insert a symbol directly from its menu, but you can copy the symbol from Excel or Google Docs and then paste it to your spreadsheet.