Thread: BIN2DEC conversion for large binary numbers
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default BIN2DEC conversion for large binary numbers
Chaps,

Look at http://sulprobil.com/html/longdec2bin__.html:
=longbin2dec(A1,11) = 822
=longbin2dec(A1,10) = -202

It just depends on how long your 2s-complement is...

Regards,
Bernd
Reply With QuoteReply With Quote