View Single Post
 
Old 08-15-2011, 03:20 AM
beingbobbyorr beingbobbyorr is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jun 2011
Posts: 3
beingbobbyorr is on a distinguished road
Default MS Excel 2007 DEC2BIN DEC2HEX

MS Excel 2007's DEC2BIN function begins to fail with decimal numbers somewhere between 2^8 and 2^9, while the DEC2HEX function begins to fail between 2^38 and 2^39.

Many engineering applications could benefit from a much larger range for these functions. Support up to at least 2^64 (but why don't you shoot for 2^128 to give yourselves some margin) would be nice for future versions, including all permutations of DEC <--> HEX, DEC <--> BIN, and HEX <--> BIN.

My present workaround (doing lots of intermediate division-and-modulus operations parsing big numbers into smaller numbers that can fit MS Excel's HEX/BIN limitations) is a huge pain in the arse.

Also, to improve readability, the DEC2BIN and HEX2BIN functions should have a passed parameter that lets the result be:

contiguous binary ("...11111101100101100111001010111010010001010001. ..") or

nibble-separated binary ("..._1111_1101_1001_0110_0111_0010_1011_1010_0100 _0101_0001_...").

/* Note: I'm not expecting any help on this.
I merely post the issue here in the hope that someone at Microsoft reads these forums for product suggestions & feedback.
. . . or is there a better place for that? */
Reply With Quote