Hex 2 Dec

[Edu-IT]

I have a bunch of Hex values in a spreadsheet that I want to convert to Dec.

 

Is there a way in SQL I can do this, as Excel is very limited in that I have to do Hex2Dec("VALUE") and replace Value manually. I can't do it as a cell reference, so it's taking too long.

 

I was hoping there's a way I could have the column in Excel and then add another Column in for it to do its conversion.

 

Any thoughts?

[Steve21]

Err why not just reference the other cell, then drag it down? Unless I'm missing something?

 

Steve

[FN-GM]

If you get the values in one column and then you can run the concatenate function in another.

 

The function would look something like this

 

=CONCATENATE("Hex2Dec(",A1,")") - This is assuming the value is in A1

[Edu-IT]

Err why not just reference the other cell, then drag it down? Unless I'm missing something?

 

Steve

Because you can't reference the cell. The 'Value' has to be a number not a cell. And FN-GM, that doesn't work either.

[tmcd35]

Because you can't reference the cell. The 'Value' has to be a number not a cell. And FN-GM, that doesn't work either.

 

I just tried in Excel and it worked fine. Cell A1 = 8a. Cell B1 =Hex2Dec(A1) = 138.

 

Are your hex values formated as text instead of no formatting?

[FN-GM]

I just tried in Excel and it worked fine. Cell A1 = 8a. Cell B1 =Hex2Dec(A1) = 138.

 

Are your hex values formated as text instead of no formatting?

 

Also checked at it works here.

 

Try building the function rule using the GUI?

Edited August 19, 2014 by FN-GM

[Edu-IT]

Think I may have made an error. ;-)

[FN-GM]

Tut Tut Tut

[Edu-IT]

It's okay, I just mistyped.