Coding Thread, Hex 2 Dec in Coding and Web Development; I have a bunch of Hex values in a spreadsheet that I want to convert to Dec.
Is there a ...
19th August 2014, 12:23 PM #1
Hex 2 Dec
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.
19th August 2014, 12:25 PM #2
Err why not just reference the other cell, then drag it down? Unless I'm missing something?
19th August 2014, 12:26 PM #3
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
19th August 2014, 02:00 PM #4
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.
Originally Posted by Steve21
19th August 2014, 02:07 PM #5
I just tried in Excel and it worked fine. Cell A1 = 8a. Cell B1 =Hex2Dec(A1) = 138.
Originally Posted by Edu-IT
Are your hex values formated as text instead of no formatting?
19th August 2014, 02:25 PM #6
Also checked at it works here.
Originally Posted by tmcd35
Try building the function rule using the GUI?
Last edited by FN-GM; 19th August 2014 at 02:31 PM.
19th August 2014, 02:37 PM #7
Think I may have made an error. ;-)
19th August 2014, 02:38 PM #8
Tut Tut Tut
19th August 2014, 07:52 PM #9
It's okay, I just mistyped.
By cchalmers83 in forum How do you do....it?
Last Post: 15th November 2012, 03:32 PM
By Michael in forum Windows
Last Post: 18th December 2008, 12:45 PM
By farmerste in forum How do you do....it?
Last Post: 25th November 2008, 12:33 AM
By russdev in forum General EduGeek News/Announcements
Last Post: 13th March 2008, 10:31 PM
By NetworkGeezer in forum Wireless Networks
Last Post: 16th March 2006, 08:16 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)