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 significant it's necessary to identify each with it's own symbol.
Hay can't seem to find that option, there are other coins but I see no option to include different one not listed.
Thank.
1 Reply
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.
