More Group Sites
Education Books
School Rankings
Jobless Net
Better Home

Help | Subscribe/Unsubscribe | Rules | Other Group Sites: Better Education | Better Education Forum
Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Saturday, February 18, 2017 2:18:12 PM(UTC)

Rank: Administration


Groups: AcademicCoachingSchool, admin, Administration, BookSeller, CatholicSchool, CoachingAdult, CoachingProfessional, CoachingSports, ExtraCurriculumCoaching, IndependentSchool, Moderator, MusicTeacher, PrivateSchool, PublicSchool, SelectiveSchool, tutor
Joined: 11/23/2008(UTC)
Posts: 521

How to convert big numbers in binary or hex in Excel
In Excel, BIN2HEX or BIN2DEC accepts a 9-bit number as its input, with the most significant bit being the sign of the number. If you enter 10 bits 1111111111, BIN2HEX will give FFFFFFFFFF and BIN2DEC will give -1. Your number has the MSB as 1, meaning the input number is negative. Negative numbers are expressed using 2's complement notation.

Note that -1 in hex is 0xFFFFFFFFFF rather than "1111111111 equals to 0xFFFFFFFFFF".

If you want to convert a big binary number with more than 9 bits, you can divide the number into 8 bits (byte) and convert each byte into hex and then concatenate them by using & or CONCATENATE function. You can even concatenate bits if they are separated into columns (related: Quickly combine text in multiple cells using this trick! [Formulas]).

In Excel, HEX2DEC, the input hex number cannot contain more than 10 hex characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If you want to convert a hex more than 10 characters, for example, 48 bits, to an decimal, you can convert last 4 bytes first and then the first 2 bytes. the result will be (decimal of 1st 2 bytes) * POWER(2,32) + (decimal of last 4 bytes).

Edited by user Saturday, February 18, 2017 2:28:09 PM(UTC)  | Reason: Not specified

Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.