How to Type a Bitcoin Symbol in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on April 3, 2023

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


  1. In the Format Cells window, click on Number and choose the Currency from the drop-down list.
    In the menu on the right side, click on the arrow to display a drop-down list for Symbol.
    From the list select ₿ bitcoin (₿ 123). 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’s added 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.

  1. In the Symbol window choose Currency Symbols and then select the bitcoin symbol.
    Click the Insert button, and then 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.

AI Formula Generator

Try for Free

See all How-To Articles