Thread: Convert Decimal fractions to binary and vice versa
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Convert Decimal fractions to binary and vice versa
On Fri, 11 Jul 2014 08:13:36 -0700 (PDT), wrote:

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!!

Search the internet for the X-Numbers add-in. The BaseChange function will do what you want. And there are many other functions which you may find of interest.
Reply With QuoteReply With Quote