Bitcoin Forum
September 26, 2018, 09:49:27 AM *
News: ♦♦ New info! Bitcoin Core users absolutely must upgrade to previously-announced 0.16.3 [Torrent]. All Bitcoin users should temporarily trust confirmations slightly less. More info.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitcoin Symbol in Excel  (Read 74 times)
BTC Turkiye
Sr. Member
****
Offline Offline

Activity: 433
Merit: 250


Anlik Coin Fiyatlari BTCkur.com


View Profile WWW
May 19, 2018, 06:06:08 PM
 #1

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

Farklı Borsaların Anlık Bitcoin, Litecoin, Ethereum ve Bitcoin Cash Kurunu Takip Edebilirsiniz.
BTCkur.com
1537955367
Hero Member
*
Offline Offline

Posts: 1537955367

View Profile Personal Message (Offline)

Ignore
1537955367
Reply with quote  #2

1537955367
Report to moderator
1537955367
Hero Member
*
Offline Offline

Posts: 1537955367

View Profile Personal Message (Offline)

Ignore
1537955367
Reply with quote  #2

1537955367
Report to moderator
1537955367
Hero Member
*
Offline Offline

Posts: 1537955367

View Profile Personal Message (Offline)

Ignore
1537955367
Reply with quote  #2

1537955367
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1537955367
Hero Member
*
Offline Offline

Posts: 1537955367

View Profile Personal Message (Offline)

Ignore
1537955367
Reply with quote  #2

1537955367
Report to moderator
1537955367
Hero Member
*
Offline Offline

Posts: 1537955367

View Profile Personal Message (Offline)

Ignore
1537955367
Reply with quote  #2

1537955367
Report to moderator
1537955367
Hero Member
*
Offline Offline

Posts: 1537955367

View Profile Personal Message (Offline)

Ignore
1537955367
Reply with quote  #2

1537955367
Report to moderator
hugeblack
Sr. Member
****
Online Online

Activity: 462
Merit: 347


Avatar 4 rent / Sig Designer https://goo.gl/34QBYf


View Profile WWW
May 19, 2018, 07:23:45 PM
 #2

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
****
Offline Offline

Activity: 433
Merit: 250


Anlik Coin Fiyatlari BTCkur.com


View Profile WWW
May 19, 2018, 07:30:48 PM
 #3

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

Farklı Borsaların Anlık Bitcoin, Litecoin, Ethereum ve Bitcoin Cash Kurunu Takip Edebilirsiniz.
BTCkur.com
hugeblack
Sr. Member
****
Online Online

Activity: 462
Merit: 347


Avatar 4 rent / Sig Designer https://goo.gl/34QBYf


View Profile WWW
May 19, 2018, 07:45:45 PM
 #4

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
****
Offline Offline

Activity: 433
Merit: 250


Anlik Coin Fiyatlari BTCkur.com


View Profile WWW
May 19, 2018, 08:14:11 PM
 #5

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


Farklı Borsaların Anlık Bitcoin, Litecoin, Ethereum ve Bitcoin Cash Kurunu Takip Edebilirsiniz.
BTCkur.com
BTC Turkiye
Sr. Member
****
Offline Offline

Activity: 433
Merit: 250


Anlik Coin Fiyatlari BTCkur.com


View Profile WWW
May 19, 2018, 08:22:10 PM
 #6

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

Farklı Borsaların Anlık Bitcoin, Litecoin, Ethereum ve Bitcoin Cash Kurunu Takip Edebilirsiniz.
BTCkur.com
BTC Turkiye
Sr. Member
****
Offline Offline

Activity: 433
Merit: 250


Anlik Coin Fiyatlari BTCkur.com


View Profile WWW
May 19, 2018, 08:29:19 PM
 #7

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.

Farklı Borsaların Anlık Bitcoin, Litecoin, Ethereum ve Bitcoin Cash Kurunu Takip Edebilirsiniz.
BTCkur.com
hugeblack
Sr. Member
****
Online Online

Activity: 462
Merit: 347


Avatar 4 rent / Sig Designer https://goo.gl/34QBYf


View Profile WWW
May 19, 2018, 09:50:07 PM
 #8

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  Smiley
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
Sr. Member
****
Offline Offline

Activity: 462
Merit: 250



View Profile
May 19, 2018, 10:45:57 PM
 #9

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?

.
                       ████████████████
                   █████████████████████████
                     ████████████████████
                        ███████████████
                          ███████████
       ███                  ███████                 ███
       █▓█▓██                 ███                 ██▓█▓█
      ██████▓██                                 █▓▓██████
     █████████▓██                             █▓▓████████
     ███████████▓▓█                         █▓▓███████████
     █████████████▓███                   ██▓▓█████████████
     ███████████▓██                        ███▓███████████
     ████████████                             ███████████
      █████████                                 ██▓██████
       ██████                 ██                  ██████
       ███                  ███████                 ███
                          ███████████
                        ███████████████
                     ████████████████████
                    ████████████████████████
                       █████████████████
Zeex
            ░▓▓▓
          ▄▓▓▓▓▓▓▓▄
         ▓▓▓▓▓▀▓▓▓▓▌
        ▐▓▓▓▌   ▓▓▓▓
        ▓▓▓▓▓▓▄▓▓▓▓▓▌
        ▐▓▓▓▓▓▓▓▓▓▓▓
      ▐▓░▓▓▓▓▓▓▓▓▓▓▌▐▓
      ▓▓▓░▓▓▓▓▓▓▓▓▓░▓▓▓
     ▓▓▓▓▌▐▓▓▓▓▓▓▓ ▓▓▓▓▌

           ▄▓▓▓▓▓        ░
           ▓▓▓▓▓▓▓      ░
            ▓ ▐▀   
       Crypto to product   
████   No fiat , No fees   ████
            ░▓▓▓
          ▄▓▓▓▓▓▓▓▄
         ▓▓▓▓▓▀▓▓▓▓▌
        ▐▓▓▓▌   ▓▓▓▓
        ▓▓▓▓▓▓▄▓▓▓▓▓▌
        ▐▓▓▓▓▓▓▓▓▓▓▓
      ▐▓░▓▓▓▓▓▓▓▓▓▓▌▐▓
      ▓▓▓░▓▓▓▓▓▓▓▓▓░▓▓▓
     ▓▓▓▓▌▐▓▓▓▓▓▓▓ ▓▓▓▓▌

           ▄▓▓▓▓▓        ░
           ▓▓▓▓▓▓▓      ░
            ▓ ▐▀   
.


                              ▄████▄
                        ▄▄█████▀▀███
                    ▄▄████▀▀     ███
              ▄▄▄████▀▀    ▄▄   ▐██
          ▄▄█████▀       ▄█▀    ██▌
     ▄▄████▀▀▀       ▄███▀      ██▌
    ████▀        ▄▄████▀       ▐██
     ██████▄▄  ▄█████▀         ██▌
          ▀████████           ▐██
            ▀████▌            ███
             ▀███  ▄██▄▄     ▐██▀
              ███▄███▀███▄   ███
              ▀███▀▀   ▀▀███▄██▌
                          ▀▀█▀▀
.

                      ▄▄▄██▄▄▄    ▄
     ██▄            ▄████████████▀
     █████▄▄       ▐█████████████▀
      █████████▄▄▄▄▐████████████▌
     █▄█████████████████████████▌
     ▀██████████████████████████
       ▀███████████████████████
       ▐██████████████████████
         ▀██████████████████▀
           ▄▄█████████████▀
     ▀████████████████▀▀
          ▀▀▀▀▀▀▀▀
CherryWarrior
Newbie
*
Offline Offline

Activity: 30
Merit: 0


View Profile
June 05, 2018, 07:03:40 AM
 #10

You're doing the right thing
Deubila
Member
**
Offline Offline

Activity: 252
Merit: 10

WPP ENERGY - BACKED ASSET GREEN ENERGY TOKEN


View Profile
August 05, 2018, 06:01:41 AM
 #11

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.

           ﹏﹏﹋﹌﹌ WPP ENERGY ﹌﹌﹋﹏﹏
☆═══━┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈━═══☆
≈ WORLD POWER PRODUCTION ≈


【 BACKED ASSET GREEN ENERGY TOKEN 】
☆═━┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈━═☆
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!