0

Advertisement

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

Advertisement

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

Advertisement

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.