+ Post New Thread
Results 1 to 9 of 9
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 ...
  1. #1

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,457
    Thank Post
    408
    Thanked 672 Times in 614 Posts
    Rep Power
    192

    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.

    Any thoughts?

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,824
    Thank Post
    372
    Thanked 544 Times in 507 Posts
    Rep Power
    184
    Err why not just reference the other cell, then drag it down? Unless I'm missing something?

    Steve

  3. #3

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,374
    Thank Post
    906
    Thanked 1,811 Times in 1,559 Posts
    Blog Entries
    12
    Rep Power
    468
    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

  4. #4

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,457
    Thank Post
    408
    Thanked 672 Times in 614 Posts
    Rep Power
    192
    Quote Originally Posted by Steve21 View Post
    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.

  5. #5

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    6,069
    Thank Post
    902
    Thanked 1,013 Times in 825 Posts
    Blog Entries
    9
    Rep Power
    350
    Quote Originally Posted by Edu-IT View Post
    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?

  6. #6

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,374
    Thank Post
    906
    Thanked 1,811 Times in 1,559 Posts
    Blog Entries
    12
    Rep Power
    468
    Quote Originally Posted by tmcd35 View Post
    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?
    Last edited by FN-GM; 19th August 2014 at 02:31 PM.

  7. #7

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,457
    Thank Post
    408
    Thanked 672 Times in 614 Posts
    Rep Power
    192
    Think I may have made an error. ;-)

  8. #8

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,374
    Thank Post
    906
    Thanked 1,811 Times in 1,559 Posts
    Blog Entries
    12
    Rep Power
    468
    Tut Tut Tut

  9. #9

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,457
    Thank Post
    408
    Thanked 672 Times in 614 Posts
    Rep Power
    192
    It's okay, I just mistyped.



SHARE:
+ Post New Thread

Similar Threads

  1. Send block / HEX / Dec to serial port
    By cchalmers83 in forum How do you do....it?
    Replies: 2
    Last Post: 15th November 2012, 03:32 PM
  2. Logistix Update Packs Dec'08
    By Michael in forum Windows
    Replies: 6
    Last Post: 18th December 2008, 12:45 PM
  3. Send hex codes to com port
    By farmerste in forum How do you do....it?
    Replies: 10
    Last Post: 25th November 2008, 12:33 AM
  4. Cancelled Intro Guide To Sims.net Thursday 20th Dec 10:30
    By russdev in forum General EduGeek News/Announcements
    Replies: 8
    Last Post: 13th March 2008, 10:31 PM
  5. Text WEP key for hex input
    By NetworkGeezer in forum Wireless Networks
    Replies: 2
    Last Post: 16th March 2006, 08:16 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •