In Excel, how can I read a cell that has a decimal value into another (different) cell while also converting this decimal value into a hexidecimal value?
2007-10-04 06:21:47 · 4 answers · asked by Andrew M 2 in Science & Mathematics ➔ Engineering
There is an Add-in called Engineering Analysis (or something like that) that has the functions (DEC2HEX, HEX2DEC, BIN2DEC, etc.) builtin. Find the Add-in and add it in.
Menu: Tools / Add-ins...
.
2007-10-04 06:27:32 · answer #1 · answered by tlbs101 7 · 3⤊ 0⤋
Excel Hex To Decimal
2016-10-30 03:44:10 · answer #2 · answered by Erika 4 · 0⤊ 0⤋
see the built-in help for DEC2HEX and HEX2DEC.
DEC2HEX(number,places)
Number is the decimal integer you want to convert. If number is negative, places is ignored and DEC2HEX returns a 10-character (40-bit) hexadecimal number in which the most significant bit is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
Places is the number of characters to use. If places is omitted, DEC2HEX uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).
2007-10-04 06:26:25 · answer #3 · answered by boogerhead9 2 · 1⤊ 0⤋
Use the Hex2Dec function. This assumes office 2003+.
2016-03-13 07:01:19 · answer #4 · answered by Anonymous · 0⤊ 0⤋