We have answer of your question!

100% solved queries, no empty question

Question: octal to binary for 12 digit numbers in excel


0

I am trying to convert a 12 digit octal number to binary

But looks like excel's inbuilt function OCT2Bin wont work for numbers greater than 517

So I tried to split the numbers and concatenate them, but it didn't work

I tried

=OCT2BIN(MID(A2,1,2))&OCT2BIN(MID(A2,3,2))&OCT2BIN(MID(A2,5,2))&OCT2BIN(MID(A2,7,2))&OCT2BIN(MID(A2,9,2))&OCT2BIN(MID(A2,11,2))

For example Octal to binary of the number

123456765432 

is

1010011100101110111110101100011010

but my formula is returning

101011100101110111110101100110100

I understand that the formula is not working because I shouldn't be breaking the numbers and concatenate them. But I am not sure how to handle it in excel

is there a way to convert 12 digit octal numbers to binary?

Question author Vignesh | Source

Answer


1


Concatenating the function is no problem because every digit in an octal number represents exactly 3 digits in binary. Your problem is that leading zeros are omitted, e.g. in your example 34o = 011100 but the first 0 is not returned so you only concatenate 11100. The OCT2BIN function has another argument in which you can determine the number of digits returned:

OCT2BIN(34) = 11100
OCT2BIN(34, 6) = 011100

As of performance: you can convert 3 octal digits at once instead of only 2.

Answer author Janb

Tickanswer.com is providing the only single recommended solution of the question octal to binary for 12 digit numbers in excel under the categories i.e excel , vba , excel-vba , macros , excel-formula , . Our team of experts filter the best solution for you.

Related Search Queries:

excel convert decimal to binary large numbers , excel decimal to binary 32 bit , excel convert binary to decimal more than 10 bits , excel binary to decimal 16 bit ,


You may also add your answer

Thanks for contributing an answer to Tick Answer!