Your Universal Remote Control Center
RemoteCentral.com
Discrete Code Hunter Forum - View Post
Up level
Up level
The following page was printed from RemoteCentral.com:

Login:
Pass:
 
 

Original thread:
Post 9 made on Monday August 21, 2006 at 19:26
johnsfine
IR Expert
Joined:
Posts:
September 2002
5,159
I just now went into Excel help and typed bin2dec.

That documented how to use the bin2dec function (which I already knew) and also reminded me that you need to load the "Analysis ToolPak" before bin2dec works and it tells you how (those details I had mostly forgotten).

Once you have bin2dec working in Excel, you can use it to convert binary to decimal. You could also use Windows calculator in view/scientific mode to convert binary to decimal. But since the data is already in Excel, using Excel should be easier.

I tried a couple searches in Excel help to see how to reverse a text string, and didn't find anything. So you'll need to dig deeper in Excel help and/or do that some more tedious way (you need to reverse the binary text string before bin2dec, because Sharp documents those bits backwards).


Hosting Services by ipHouse