Wednesday, December 30, 2009

Is there a function on Microsoft Excel that allows conversion of decimal numbers to hexadecimal?

I need a function(s) or macro that would allow me to take a number in base-10 decimal format and convert it to hex. Also counting/adding the hex numbers as more decimal numbers are added to a list.Is there a function on Microsoft Excel that allows conversion of decimal numbers to hexadecimal?
Take a look at the DEC2HEX function:





DEC2HEX(number,places)





=DEC2HEX(100, 4) Converts decimal 100 to hexadecimal with 4 characters (0064)





You will need to have the Analysis ToolPak addin loaded.Is there a function on Microsoft Excel that allows conversion of decimal numbers to hexadecimal?
right click the designated cell(s), and change the type to hex or decimal.
  • soccer
  • No comments:

    Post a Comment