Hex Format

[Dan Olsen]

Is there a way to tell a cell in Excel to take the format
of an 8 digit hex number? (ex. ff82dca1) I want it to
take the format and increment the hex value as I drag the
corner of the cell over multiple cells. Right now I give
it two cells of hex values (bfff7c04 and bfff7c00) so it
should decrement 4 each cell. When I drag down it
increments by 4 instead. I need it to decrement as I go
down the worksheet. It also just increments the last
number (ex. bfff7c04 bfffc700 bfffc704 ... bfffc100
bfffc104). What can I do to correctly work with hex
values?

 

[Biff]

Hi Dan,

This is probably not what you had in mind but it should
get you where you want to be.

The problem is that the HEX value as entered, ff82dca1, is
just a TEXT string to XL.

Convert the HEX values to DECIMAL using the HEX2DEC()
function. Do whatever you need to do on the decimal values
then convert those back to HEX using the DEC2HEX()
function. Not very elegant but.......

Biff

 

[Stefano Gatto]

I don't have HEX2DEC(). Is it part of an add-in?

Stefano

 

[Biff]

Hi Stefano,

Yes, it's part of the Analysis ToolPak add-in. If you say
that you don't have it, it may be that it's just not
loaded. To check goto TOOLS>ADD-INS. In the dialog that
opens look for Analysis ToolPak. If it's in the list make
sure to check it then OK out and it will then be available.

If it's not in the list, then you will have to install it
from your original program distribution disc. You can do
that from the Add/Remove Program utility of the OS.

Biff