Forum Discussion
Unicode Library? not getting correct symbol.
Good evening,
Can someone point me in the right direction? I'm trying to include an exclamation mark using the UNICHAR function but I'm obviously doing something wrong:
Is there a library somewhere with the correct UNICODEs? the one I'm using is rendering the wrong symbol.
Thanks,
Paul.
UNICHAR expects decimal codes. Your information contains hexadecimal codes.
Hex 2757 = Decimal 10071.
You can find a conversion function in the link below this video (the link starts at the point where the function is explained).
This is how the function can be used to convert "2757" from hexadecimal to decimal:
= fnNumberBaseConversion("2757", 16, null)Thank you Marcel for the explanation and video!
EDIT: I've been looking around and found an online conversion tool if anyone is interested:
3 Replies
- MarcelBeugCommunity Champion
UNICHAR expects decimal codes. Your information contains hexadecimal codes.
Hex 2757 = Decimal 10071.
You can find a conversion function in the link below this video (the link starts at the point where the function is explained).
This is how the function can be used to convert "2757" from hexadecimal to decimal:
= fnNumberBaseConversion("2757", 16, null)- PaulDBrownCommunity Champion
Thank you Marcel for the explanation and video!
EDIT: I've been looking around and found an online conversion tool if anyone is interested:
- v-chuncz-msftCommunity Support
By the way, you may help accept the solution above. Your contribution is highly appreciated.