Josh Koffman wrote: > Hi all. I have a list of numbers in an Excel file in decimal > format. I would like to tranlate these numbers to hexadecimal > format. Is there a way to do that using Excel? From (Exel -> VBA -> Help): *********************************** Hex Function Returns a String representing the hexadecimal value of a number. Syntax Hex(number) The required number argument is any valid numeric expression or string expression. Remarks If number is not already a whole number, it is rounded to the nearest whole number before being evaluated. Hex Function Example This example uses the Hex function to return the hexadecimal value of a number. Dim MyHex MyHex = Hex(5) ' Returns 5. MyHex = Hex(10) ' Returns A. MyHex = Hex(459) ' Returns 1CB. *********************************** Mike. P.S.: > A common mistake that people make when trying to design > something completely foolproof is to underestimate the > ingenuity of complete fools. > -Douglas Adams If you think of something to be foolproof, the fools are always greater then the proof! Eduard Teller American Nuclear Physicist -- http://www.piclist.com hint: PICList Posts must start with ONE topic: [PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads