Forum Discussion
Solved
HEX2DEC Issue
Dear Experts,
Greetings!
In attached sheet I want to convert Hex to Decimal, but somehow in Column "D", I am getting "#NUM" Error:-
Please suggest.
Thanks in Advance,
Br,
Anupam
In general it works
As variant you may have extra non-printable characters in C1. What =LEN(C1) returns?
5 Replies
In general it works
As variant you may have extra non-printable characters in C1. What =LEN(C1) returns?
- Thanks a lot Sergei, I got what the issue was..
If you copy/paste that from web, most probably there is non-breaking space (code 160) within text. Something like
=HEX2DEC( LEFT(C1,2) )could work.
Or you may ignore column C and take texts from B
=HEX2DEC( MID(B1,9,2) )
I asked my secret contact at Microsoft and his answer was:
If the value is not a valid hexadecimal number, HEX2DEC returns the #NUM! error.
