View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ahmedmidany ahmedmidany is offline
external usenet poster
 
Posts: 1
Default BIN2DEC conversion for large binary numbers

Hello All,

I need your help, i want to convert large binary numbers using excel
but whenever i use the BIN2DEC function the result is negative which
is not correct.

Ex. BIN2DEC(1100110110) the result is -202 but if i use the calculator
the result is 822 which is the correct value

Any ideas? what shall i do to have the correct value?

Thanks in advance
A.M.