How can i convert 16 bit binary to decimal value?

[Senthillee]

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

 

[Gary''s Student]

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

 

[Vijay]

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