#1
|
|||
|
|||
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? */ |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2007 to Outlook 2007 - task import possible? | mjwillyone | Outlook | 2 | 07-05-2023 07:23 AM |
Excel 2007 replace | Jim WV | Excel | 2 | 07-17-2011 01:44 AM |
Excel 2007 | IRoy | Excel | 2 | 04-28-2011 02:26 AM |
Excel 2007 to Word 2007 Labels mail merge not working | rec | Mail Merge | 0 | 07-31-2010 10:45 AM |
Example req for VBA app in excel 2007 (for Office 2007) | aligahk06 | Excel | 0 | 08-28-2009 04:36 AM |