Hi
I got csv file from a ifferent tool which is giving me 32bit binary in form of 1.00011E+30. Whole table has around 1000 entries in 2 separate columns.
I need to convert that in decimal for further calculations. I tried Bin2hex formula but seems it'll not work with the size of binary number.
Please let me know if you have any option for me.
Regd,
Anuj
Do any of these solutions work?
http://stackoverflow.com/questions/2...-large-numbers
or use this
=SUMPRODUCT(--MID(A1,LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1))),1),(2^(ROW(INDIRECT("1:"&LEN(A1)))-1)))
You need to enter the binary number as text if more than 15 digits
Source: http://www.pcreview.co.uk/threads/bi...mbers.3939379/
Last edited by Special-K; 05-18-2016 at 07:49 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks