Bitcoin Forum

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


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

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 (https://i.imgur.com/635Rk6q.png)

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

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 (https://docs.google.com/spreadsheets/d/1evdVtcLg8LIUj2Eu19lclUGuP8N0mhFSXRyDBhPIoQQ/edit#gid=0)
check -------> https://i.imgur.com/Hd9khdv.png, click here (https://i.imgur.com/Hd9khdv.png) if the picture does not appear.

---

I do not think this method affects the rest of your work just will add a new symbol

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"


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

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

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.

I'm sorry, I use Windows 8, so the style is different
Great, thanks  :)
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

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

You're doing the right thing

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.