Hex, Hex$ Functions |
No
Hex(number)
number
Use: Required
Data Type: Numeric or String
A valid numeric or string expression.
String representing the hexadecimal value of number.
Returns a string that represents the hexadecimal value of a number.
If number contains a fractional part, it's rounded automatically to the nearest whole number prior to processing.
number must evaluate to a numeric expression that ranges from –2,147,483,648 to 2,147,483,647. If the argument is outside this range, runtime error 6, "Overflow," results.
The return value of Hex is dependent upon the value and type of number :
number | Return Value |
---|---|
Null | Null |
Empty | Zero (0) |
Any other number | Up to eight hexadecimal characters |
If the value of number is known beforehand and isn't the result of an expression, you can represent the number as a hexadecimal by simply affixing &H to number. Each of the following two statements assigns a hexadecimal value to a variable, for instance:
lngHexValue1 = &HFF ' Assigns 255 lngHexValue2 = "&H" & Len(dblNumber) ' Assigns 8