Can Excel convert from hex to decimal and vice versa?

L

LordJezo

Lotus has a nice easy function that looks sort of like hex>dec or
something just as simple.


Is there anyway I can get Excel to convert a column of numbers into
hexadecimal in an adjacent column or convert back from decimal to hex?
 
K

Ken Wright

Install the Analysis Toolpak addin and then take a look at the DEC2HEX and
HEX2DEC functions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
Conversion of Dec numbers to Bin, Oct and Hex and visa versa 1
decimal to hex to binary 1
convert Hex to UTF8 and Vice Versa 9
Excel 2007 VBA: Convert laaaaarge number to Hex 27
changing the decimal to hex 5
How do i convert angles from degrees,minutes, seconds to decimal 1
Hexadecimal to Decimal (and vice versa) 5

Top