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?
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.