| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal to Hexadecimal
So, my company tracks items based on DEC and HEX, some with one, some with
the other. I'm tryign to create a formula that will convert items that have, say DEC to HEX and vice versa. Problem is, when I attempt DECTOHEC and HEXTODEC, it doesn't match what I get using my company's lookup tool (an arduous process) Here's what the company conversion are for a sample set of numbers: DEC HEX 02313552326 17cecac6 02313552451 17cecb43 02313552469 17cecb55 02313552512 17cecb80 02313552538 17cecb9a 02313552779 17cecc8b 02313552798 17cecc9e 02313552829 17ceccbd 02313552891 17ceccfb 02313552900 17cecd04 05112837432 33C3E238 And Dec2Hex() gives me: DEC HEX 02313552326 89E601C6 02313552451 89E60243 02313552469 89E60255 02313552512 89E60280 02313552538 89E6029A 02313552779 89E6038B 02313552798 89E6039E 02313552829 89E603BD 02313552891 89E603FB 02313552900 89E60404 05112837432 130BFB538 I'm missing something... :-/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to convert a column of hexadecimal numbers to decimal num | Excel Discussion (Misc queries) | |||
| h:mm to decimal value | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| CONVERT HEXADECIMAL CELL TO DECIMAL NUMBER | Excel Worksheet Functions | |||
Threaded Mode
