Forum Discussion
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...
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
You may add another zero after the dot in format string. More about custom number formats is here Excel custom number formats
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