format numbers in hexadecimal

[stan_shepherd]

I'd like to display numbers in hexadecimal and still be able t
calculate with them.

DEC2HEX() and HEX2DEC() are available as functions (I think they're i
the Analysis ToolPak) but I'd rather avoid adding these to ever
calculation.

That is, for example, I don't want to have to change every formula
"=A1+A2" to "=dec2hex(hex2dec(A1)+hex2dex(A2))".

Any idea how to add "Hex" as another numeric format choice, so tha
numbers are displayed directly in hex

 

[hgrove]

stan_shepherd wrote...

I'd like to display numbers in hexadecimal and still be able to
calculate with them. ...
That is, for example, I don't want to have to change every >formula

"=A1+A2" to "=dec2hex(hex2dec(A1)+hex2dex(A2))".
...

Just plain not possible. Your second formula above is the *ONLY* way t
calculate with hexadecimal numbers in Excel. If this doesn't work fo
you, you're going to have to find different software to use, but n
spreadsheet I'm aware of provides hexadecimal (or octal or binary
number formatting