Returns a string representing the hexadecimal value of a number.
Hex(number)
The number argument is any valid numeric or string expression.
If number is not already a whole number, it is rounded to the nearest whole number before being evaluated.
If number is |
Hex returns |
Null |
Null. |
Empty |
Zero (0). |
Any other number |
Up to eight hexadecimal characters. |
You can represent hexadecimal numbers directly by preceding numbers in the proper range with &H. For example, &H10 represents decimal 16 in hexadecimal notation.
Oct Function.
This example uses the Hex function to return the hexadecimal value of a number.
MyHex = Hex(5) ' Returns 5.= Hex(10) ' Returns A.= Hex(459) ' Returns 1CB.