problem changing Hex2Dec in excel

Hi,

I have a problem of converting Hex to Decimal From column H to column I.
seperate-hex2dec.xls
csharp_learnerAsked:
Who is Participating?
 
FlysterConnect With a Mentor Commented:
HEX2DEC can only have 10 characters. Try using:

=HEX2DEC(SUBSTITUTE(G2," ",""))

Flyster
0
 
csharp_learnerAuthor Commented:
thanks for the reply,
i tried using your code on column I but it is not successful.
seperate-hex2dec.xls
0
 
FlysterCommented:
Not sure what the problem is. I'm working with 2007 and it works. Should work with 2003 also. I'll check on my laptop.
seperate-hex2dec.xls
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Make sure that the analysis toolpak is installed.
0
 
FlysterCommented:
 I should have looked at this more closely to begin with. I didn't notice the code in H column. Use the SUBSTITUTE formula in that column and not the I column. See attached.
seperate-hex2dec.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.