Menu

Convert Decimal fractions to binary and vice versa

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.worksheet.functions

Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline

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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need to convert foot pounds of energy to joules and vice versa	Sid	Excel Worksheet Functions	6	January 28th 09 11:37 PM
Hexadecimal to Decimal (and vice versa)	Toria	Excel Worksheet Functions	5	January 22nd 09 09:43 PM
Function To Convert Liters To Imperial Gallons & Vice Versa	Dave Gibson	Excel Worksheet Functions	3	September 24th 05 09:03 PM
Formula to convert/transpose columns to rows (and vice versa)	markx	Excel Worksheet Functions	5	March 10th 05 02:18 PM

All times are GMT +1. The time now is 08:41 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement