Format cells for hexadecimal numbers

[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.

 

[Gary''s Student]

Text

 

[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.