Unicode Library? not getting correct symbol.

[PaulDBrown]

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.

[MarcelBeug · Accepted solution]

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)

[MarcelBeug · Accepted solution]

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)

[PaulDBrown · Accepted solution]

Thank you Marcel for the explanation and video!

EDIT: I've been looking around and found an online conversion tool if anyone is interested:

https://www.binaryhexconverter.com/hex-to-decimal-converter

[v-chuncz-msft]

@PaulDBrown,

By the way, you may help accept the solution above. Your contribution is highly appreciated.