/text/sbasic/shared/03080801.xhp

Hex function Hex Function [Runtime] Returns a string that represents the hexadecimal value of a number.

Syntax: Hex (Number) Return value: String Parameters: Number: Any numeric expression that you want to convert to a hexadecimal number. Example: Sub ExampleHex REM uses BasicFormulas in $[officename] Calc Dim a2, b2, c2 as String a2 = "&H3E8" b2 = Hex2Int(a2) MsgBox b2 c2 = Int2Hex(b2) MsgBox c2 End Sub Function Hex2Int( sHex As String ) As Long REM Returns a Long-Integer from a hexadecimal value. Hex2Int = clng( sHex ) End Function Function Int2Hex( iLong As Long) As String REM Calculates a hexadecimal value in Integer. Int2Hex = "&H" & Hex( iLong ) End Function