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).
|
|
|