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?

# 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

#### Share this

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.

## You may also add your answer