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 sug...
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) )