SOLVED

Custom Currency

%3CLINGO-SUB%20id%3D%22lingo-sub-1815560%22%20slang%3D%22en-US%22%3ECustom%20Currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815560%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%3C%2FP%3E%3CP%3EHow%20do%20I%20add%20my%20own%20currencies%20to%20Excel%20so%20I%20can%20use%20it%20to%20format%20cells%3F%3C%2FP%3E%3CP%3EOne%20may%20wonder%20as%20to%20why%20but%20I'm%20working%20with%20crypto%20currencies%20and%20while%20I%20could%20use%20the%20Thai%20Baht%20symbol%20for%20Bitcoin%2C%20I%20prefer%20'BTC'%20and%20besides%20that%20I%20have%20other%20coins%20that%20I%20need%20to%20include%20(USDT%20%26amp%3B%20BNB).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20on%20this%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1815560%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815634%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F844835%22%20target%3D%22_blank%22%3E%40Seb_SL%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20find%20almost%20currency%20symbol%20of%20every%20country%20in%20Cell%20format%2C%2C%20Currency%2C%2C%2C%20other%20wise%20you%20may%20use%20Custom%20Format%2C%2C%2C%20and%20create%20like%20these%200.00%20%22USDT%22%26nbsp%3B%20%26nbsp%3B0.00%20%22BNB%22.%26nbsp%3B%20or%20like%26nbsp%3B%22USDT%22%200.00.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1603608579460.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229077i9B5DE310A423E16B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rajesh-S_0-1603608579460.png%22%20alt%3D%22Rajesh-S_0-1603608579460.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815659%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20quick%20reply%20Rajesh.%20It%20did%20get%20me%20one%20step%20closer%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EIt%20does%20however%20give%20me%20a%20fraction%20of%20the%20number.%20Not%20sure%20why...%3CBR%20%2F%3EWhen%20entering%20a%20value%20of%2025%20it%20gives%20me%20a%20rounded%20fraction%20of%200.03%20BNB%3CBR%20%2F%3EI%20could%20solve%20it%20through%20a%20formula%20but%20I%20assume%20there%20is%20a%20better%20way%20of%20doing%20it%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EAny%20tips%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22customCurrency.png%22%20style%3D%22width%3A%20280px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229078i5B330BB8D164E92C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22customCurrency.png%22%20alt%3D%22customCurrency.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi there.

How do I add my own currencies to Excel so I can use it to format cells?

One may wonder as to why but I'm working with crypto currencies and while I could use the Thai Baht symbol for Bitcoin, I prefer 'BTC' and besides that I have other coins that I need to include (USDT & BNB).

 

Any advice on this?

5 Replies
Highlighted

@Seb_SL 

 

You may find almost currency symbol of every country in Cell format,, Currency,,, other wise you may use Custom Format,,, and create like these 0.00 "USDT"   0.00 "BNB".  or like "USDT" 0.00. 

 

 

Rajesh-S_0-1603608579460.png

 

 
 

 

 

Highlighted

@Rajesh-S 

 

Thanks for the quick reply Rajesh. It did get me one step closer
It does however give me a fraction of the number. Not sure why...
When entering a value of 25 it gives me a rounded fraction of 0.03 BNB
I could solve it through a formula but I assume there is a better way of doing it

Any tips?

customCurrency.png

Highlighted

@Seb_SL 

You may add another zero after the dot in format string. More about custom number formats is here Excel custom number formats 

Highlighted
Best Response confirmed by Seb_SL (New Contributor)
Solution

@Sergei Baklan @Rajesh-S

 

The solution (in case someone else is looking for the same thing) is to write:

# ##0.00\ [$BNB]


This will not affect the decimals (create a fraction) and will output the desired format

customCurrency2.png

Highlighted

@Seb_SL 

 

  • Since you have not disclosed the data you have, otherwise it's working properly. Check the screen shot below:

Rajesh-S_0-1603697919546.png