Format cells for hexadecimal numbers

R

Ricsastir

How do I format cells so I can enter numbers directly in hex format. I will
then operate on them and also convert to binary or decimal using the hex2bin
function.
 
H

Homey

dont forget excel only can do math on decimal numbers. you can put A in a
cell but excel not see it as 10, just a text. every hex or bin number must
be convert to dec to do math.

| How do I format cells so I can enter numbers directly in hex format. I
will
| then operate on them and also convert to binary or decimal using the
hex2bin
| function.
 
Top