Hex Function/text/sbasic/shared/03080801.xhpHex functionHex FunctionReturns a string that represents the hexadecimal value of a number.Syntax:Hex (Number)Return value:StringParameters:Number: Any numeric expression that you want to convert to a hexadecimal number.Example:Sub ExampleHex' uses BasicFormulas in %PRODUCTNAME CalcDim a2, b2, c2 As String a2 = "&H3E8" b2 = Hex2Lng(a2) MsgBox b2 c2 = Lng2Hex(b2) MsgBox c2End SubFunction Hex2Lng(sHex As String) As Long' Returns a 32 bits signed integer number from an 8 digits hexadecimal value. Hex2Lng = clng( sHex )End FunctionFunction Lng2Hex(iLong As Long) As String' Calculates the 8 digits hexadecimal value out of a 32 bits signed integer number. Lng2Hex = "&H" & Hex( iLong )End Function