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%3CLINGO-SUB%20id%3D%22lingo-sub-1816254%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816254%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%0A%3CP%3EYou%20may%20add%20another%20zero%20after%20the%20dot%20in%20format%20string.%20More%20about%20custom%20number%20formats%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fcustom-number-formats%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExcel%20custom%20number%20formats%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@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

 

 
 

 

 

@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

@Seb_SL 

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

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

@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