Bitcoin Symbol in Excel | Bitcointalksearch.org

Deubila

member

Activity: 252

Merit: 10

Quote from: hugeblack on May 19, 2018, 02:23:45 PM

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.

CherryWarrior

newbie

Activity: 23

Merit: 0

You're doing the right thing

moynul2050

sr. member

Activity: 812

Merit: 250

Quote from: hugeblack on May 19, 2018, 02:23:45 PM

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?

hugeblack

legendary

Activity: 2688

Merit: 3983

Quote from: BTC Turkiye on May 19, 2018, 03:14:11 PM

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

Quote from: BTC Turkiye on May 19, 2018, 03:22:10 PM

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

Great, thanks

Quote from: BTC Turkiye on May 19, 2018, 03:29:19 PM

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

BTC Turkiye

sr. member

Activity: 472

Merit: 254

Anlik Coin Fiyatlari BTCkur.com

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.

BTC Turkiye

sr. member

Activity: 472

Merit: 254

Anlik Coin Fiyatlari BTCkur.com

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

BTC Turkiye

sr. member

Activity: 472

Merit: 254

Anlik Coin Fiyatlari BTCkur.com

Quote from: hugeblack on May 19, 2018, 02:23:45 PM

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"

Quote

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

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

hugeblack

legendary

Activity: 2688

Merit: 3983

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

sr. member

Activity: 472

Merit: 254

Anlik Coin Fiyatlari BTCkur.com

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

legendary

Activity: 2688

Merit: 3983

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

sr. member

Activity: 472

Merit: 254

Anlik Coin Fiyatlari BTCkur.com

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

Topic: Bitcoin Symbol in Excel (Read 184 times)