Forum Discussion

Seb_SL's avatar
Seb_SL
Copper Contributor
Oct 25, 2020
Solved

Custom Currency

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 Bit...
excel
  • Seb_SL's avatar
    Seb_SL
    Oct 25, 2020

    SergeiBaklan @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

Seb_SL's avatar
Seb_SL
Copper Contributor
Oct 25, 2020

Rajesh_Sinha 

 

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?

Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
Oct 26, 2020

Seb_SL 

 

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

 

Resources