+ Reply to Thread
Results 1 to 3 of 3

Convert Binary info in a column to Decimal

  1. 03-17-2014, 01:04 PM #1
    VIRTUAL007
    VIRTUAL007 is offline
    Registered User
    Join Date
    03-07-2014
    Location
    dallas, texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Convert Binary info in a column to Decimal

    Hello ,
    Please help, I am trying to convert 14 to 15 digits lengthy Binary value to number.

    The formula =BIN2DEC(A2) is giving error #NUM
    Please see the attachment.

    101111100001010
    101111100001010
    101111100001010
    101111000011100
    101111000011100
    101111000011100
    110001000001010


    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-17-2014, 01:23 PM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Convert Binary info in a column to Decimal

    I believe according to Microsoft the BIN2DEC function can't handle more than 10 bits...which seems really stupid....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  3. 03-17-2014, 02:08 PM #3
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Convert Binary info in a column to Decimal

    Hi,

    A workaround:

    =SUMPRODUCT((MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))*2^(LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Binary to Decimal converter
    By thedudester1978 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 12:42 PM
  2. decimal to binary
    By boardmaker in forum Excel General
    Replies: 4
    Last Post: 06-13-2006, 04:10 PM
  3. [SOLVED] decimal to binary conversion
    By tam in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-29-2005, 01:05 PM
  4. How to convert binary to decimal & vice versa?
    By hmmm in forum Excel General
    Replies: 5
    Last Post: 08-02-2005, 11:05 PM
  5. [SOLVED] How can I convert binary numbers to decimal when they are larger .
    By Nebulae in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2005, 01:06 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1