Can Excel convert from hex to decimal and vice versa?

Lotus has a nice easy function that looks sort of like hexdec 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?


---
Message posted from http://www.ExcelForum.com/

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"LordJezo " wrote in message
...
Lotus has a nice easy function that looks sort of like hexdec 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?


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004

Check out the DEC2HEX and HEX2DEC functions in Help.

On Wed, 7 Jul 2004 14:16:45 -0500, LordJezo
wrote:

Lotus has a nice easy function that looks sort of like hexdec 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?


---
Message posted from http://www.ExcelForum.com/