This tutorial demonstrates how to type a bitcoin symbol in Excel and Google Sheets.
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.
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.
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.
As a result, all numbers are formatted as currencies with a bitcoin symbol.
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.
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.
As a result, the bitcoin symbol is in the selected cell.
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.