Anyone know how to use hex formula that reads a cell? I want to .

Anyone know how to write macro/formula that will convert "a column" of Hex to
decimal? I'm looking for a hex conversion by cell content, rather than hard
coded value in "quotes".

How about the Hex2Dec worksheet function found in the analysis toolpak.

See Excel Help on the Hex2Dec function for details.

--
Regards,
Tom Ogilvy

"KarenSue33" <[email protected]> wrote in message
news:[email protected]...
> Anyone know how to write macro/formula that will convert "a column" of Hex
to
> decimal? I'm looking for a hex conversion by cell content, rather than
hard
> coded value in "quotes".