Forum Discussion
Bs, BsF, BsS, BsD
hello please how can I add a new currancy category in Excel? In Venezuela the Bolívar (Bs) has undergon changes each one with a different symbol. (Bs, BsF, BsS, BsD). The devaluation Is so significa...
Bs, BsF, BsS, BsD
Select the cells that should have the "Bs" format and enter the following under "Format Numbers/Custom":
#.##0.00 Bs;[Red]-#.##0.00 Bs
or
#.##0.00 BsF;[Red]-#.##0.00 BsF
..Etc.
Your numbers are now in the "Bs" format or whatever format is desired. Minus numbers are shown in red.
...more informations you will find in the upper link.