Bs, BsF, BsS, BsD

Copper Contributor

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

@Moses_Grimaldo 

Format numbers as currency

 

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.