Jul 05 2022 02:02 PM
Hello. On July 1, Sierra Leone redenominated their currency and created a new currency symbol. Old Leones are denoted SLL and new Leones are denoted SLE.
SLL 1,000 = SLE 1
On Mac, I am unable to add custom currency characters, so I am requesting that SLE be added to the list of currency symbols. Thanks!
Jul 07 2022 05:43 AM
Select worksheet or cells range orcolumn or rows or cell,
right mouse button,
format cells...
Counting,
Custom
input in type:
#.##0.00 "SLE";[Red]-#.##0.00 "SLE"
OK
Every time you enter a number, the currency symbol "SLE" appears behind it.
Hope I could help you with these workaround.
I know I don't know anything (Socrates)
Jul 12 2022 01:14 PM
@NikolinoDE Thanks! I appreciate the help! I ended up using [$SLE] #,##0;[Red][$SLE] #,##0