Hi all
I need to convert a list of numbers from Decimal to combination of decimal and hexadecimal.
Namely, the whole number I need to convert from Decimal to Hexadecimal. The decimal part of the number I will merged with the Hexadecimal.
E.g.: Number 29.7764031619 will be split to 2 parts
a) The whole number, which is 29. The whole part will be converted to Hexadecimal, and from 29 will become 1D.
b) The decimal part, which is .7764031619
After that, we'll merged the values in parts a) and b), and we'll get 1D.7764031619
The formula example for this transformation can be found in the attached file in cells (D5:D11).
I need to create code, which will automatically convert the values in a range from Decimal to the format shown above.
I've started writing a code to make this changes in range (B19:B25), but I have problem with incorporating the decimal part.
Thank you for your help with it.
Igor
Dec 2 Hex.xlsbEnd Sub
Bookmarks