HEX number to decimal conversion

[ashokchl]

Hi

How to convert HEX NUMBER to DECIMAL.

I tried with =HEX2DEC(A1) but it is showing error. Can you please help me out.

 

[NARAYANK991]

Hi Ashok ,


HEX2DEC depends on the input number being a string e.g. if A1 contains the string FEDC , which can be a hexadecimal number , then HEX2DEC(A1) will give 65244.


If A1 contains the number 123 , then HEX2DEC(A1) will interpret 123 as a hexadecimal number and return the value 291.


Narayan

 

[ashokchl]

Narayan,


I am trying with C25A40D6 to convert decimal, but showing error.

 

[NARAYANK991]

Hi Ashok ,


With the hex number you have posted , I get 3260694742 as the result. There is no problem.


Narayan

 

[ashokchl]

But i am getting error. Is there any Add-on need to add?

And also i am using 2003 version.

 

[NARAYANK991]

Hi Ashok ,


Because you are using Excel 2003 , you will have to install the Analysis Toolpak in order to use this function. In Excel 2007 , no add-in is required.


Narayan

 

[ashokchl]

Thanks a lot Narayan. It works fine.