Bitcoin Symbol in Excel

[BTC Turkiye]

Anyone knows how to automatically put ₿ in front of all number amounts in an excel sheet and still keep the cell as a number to be used in somewhere else?

I tried to use the currency setting but Bitcoin is not there. The symbol is only listed in the Symbol box. So you have to manually added  which means when you add it like below

Code:

=" ₿ "&SUM(E3:E34)

You can't get the number of that cell and use it somewhere else because it has a manually put symbol in it

[hugeblack]

Yes, you can add it automatically. Just modify your currency to Bitcoin or follow this(for windows only) /* you must have Office 2016:
1. close all office applications.
2. open Control Panel ----> Clock, Language, and Region category.
3. click Region then additional settings ---> Currency tab
4. Paste your bitcoin Currency symbol on Currency symbol *
5. click ok, then apply and ok.
6. open excel then use same way for adding $.
* you can get bitcoin symbol from "0234 alt+x".


This is a screen from my PC ----> https://i.imgur.com/635Rk6q.png

[BTC Turkiye]

Yeah but this way entire windows will use Bitcoin instead of dollar in every application and software. I just need to have this in one specific excel sheet

[hugeblack]

No, if you use this way you will add BTC to your accounting symbols. So you will have BTC, $, .... etc.
You can use it like any other accounting symbols.
check -------> https://docs.google.com/spreadsheets/d/1evdVtcLg8LIUj2Eu19lclUGuP8N0mhFSXRyDBhPIoQQ/edit#gid=0
check -------> https://i.imgur.com/Hd9khdv.png, click here if the picture does not appear.
I do not think this method affects the rest of your work just will add a new symbol

[BTC Turkiye]

Yes, you can add it automatically. Just modify your currency to Bitcoin or follow this(for windows only) /* you must have Office 2016:
1. close all office applications.
2. open Control Panel ----> Clock, Language, and Region category.
3. click Region then additional settings ---> Currency tab
4. Paste your bitcoin Currency symbol on Currency symbol *
5. click ok, then apply and ok.
6. open excel then use same way for adding $.

Could you please give me the directions for windows 10?
I don`t see additional settings. There`s "Additional date, time......" but no currency tab there or in "Advanced keyboard settings"

* you can get bitcoin symbol from "0234 alt+x".

When I write this in an excel cell, it doesnt give me anything

[BTC Turkiye]

Got it now... Hey thank you very much. You`re awesome!~

[BTC Turkiye]

Actually hold on. Do you know if there`s a way to add more than one currency?
When I follow your steps and add litecoin now, it takes over Bitcoin symbol.

[hugeblack]

Could you please give me the directions for windows 10?
I don`t see additional settings. There`s "Additional date, time......" but no currency tab there or in "Advanced keyboard settings."

I'm sorry, I use Windows 8, so the style is different

Got it now... Hey, thank you very much. You`re awesome!~

Great, thanks 

Hold on. Do you know if there`s a way to add more than one currency?
When I follow your steps and add litecoin now, it takes over Bitcoin symbol.

This is because this option is available if Office does not support your country's currency.
There is a code to add new symbols, but I do not remember it now "will update when remembering," but this is the easiest way.
I do not know why this symbol has not yet been added but may be automatically supported in the future version

[moynul2050]

Yes, you can add it automatically. Just modify your currency to Bitcoin or follow this(for windows only) /* you must have Office 2016:
1. close all office applications.
2. open Control Panel ----> Clock, Language, and Region category.
3. click Region then additional settings ---> Currency tab
4. Paste your bitcoin Currency symbol on Currency symbol *
5. click ok, then apply and ok.
6. open excel then use same way for adding $.
* you can get bitcoin symbol from "0234 alt+x".


This is a screen from my PC ----> https://i.imgur.com/635Rk6q.png

Very interesting and want to try it, does this work on all versions of office?
I use office 2007?

[CherryWarrior]

You're doing the right thing

[Deubila]

Yes, you can add it automatically. Just modify your currency to Bitcoin or follow this(for windows only) /* you must have Office 2016:
1. close all office applications.
2. open Control Panel ----> Clock, Language, and Region category.
3. click Region then additional settings ---> Currency tab
4. Paste your bitcoin Currency symbol on Currency symbol *
5. click ok, then apply and ok.
6. open excel then use same way for adding $.
* you can get bitcoin symbol from "0234 alt+x".


This is a screen from my PC ----> https://i.imgur.com/635Rk6q.png

Thank you for sharing, now I know this. Before I completely copy and paste them again, it takes time. In the excel application spoiled the choice of electronic money management arrangements look very eye-catching. Very great thank you very much.