How can i convert 16 bit binary to decimal value?


G

Guest

Hi,
I want to convert 16bit Binary to Decimal value. Like the cell A1 contains
one 8 bit equivalent decimal value.First i should convert this A1 value and
put it in B1 Cell. The same 8bit equivalent decimal no is there in C1 and i
should convert it and put in D1 cell.
Finally the both B1 and D1(binary value) should concatinate, and this
concatinated 16 Binary value should be written in E1 cell.
Please anyone can help for this??? Need it urgently
 
Ad

Advertisements

G

Guest

In A1 hru E1 enter:
19 =DEC2BIN(A1) 23 =DEC2BIN(C1) =B1&D1
and you will see:
19 10011 23 10111 1001110111
 
Ad

Advertisements

G

Guest

Hi

Answer of your question, Go to format cells (where it is right click of the
mouse)
then go to number page select the number where it is the category.Then
decimal value make it 16.Then u r problem is solved
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top