Thread: Convert Decimal fractions to binary and vice versa
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] vinod.booshanan@gmail.com is offline
external usenet poster
  
Posts: 1
Default Convert Decimal fractions to binary and vice versa
Hello all,

How can I convert a decimal fraction (for example 10.5) to binary form and vice versa (i.e., if I have a binary form such as 10010.011 back to decimal form)?

The DEC2BIN function in Excel works for Whole numbers and not fractions.

Please suggest!!
Reply With QuoteReply With Quote