Num Base

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Num Base


Change the number base of integer values, e.g. decimal to hexadecimal.



Convert from decimal (base 10) to hexadecimal (base 16):


Change from decimal (base 10) to hexadecimal (base 16)

Convert from guessed base to decimal (base 10):


Change from guessed base to decimal (base 10)






Check the column(s) you wish to convert.

Set Base from to the base of the current values. If you set it to Guess, it will guess the base for each column by looking at some of the values, Numbers starting with 0x (e.g. 0x123) are assumed hexadecimal (base 16). The base guessed in output in the Info tab.

Set Base to to the base wanted.



The values to be converted should be integers (whole values) without group separators (e.g. no commas or decimal points).

If Base from and Base to are the same, no change is made.

Negative numbers are represented using unsigned values (e.g. twos complement for binary) if Base to is anything other than 10.

Warnings are shown in the Warnings tab for non-integer values.

Use Copy Cols to copy columns before conversion.

Use Num Format to change the format of numbers (e.g. remove group separators).

You can use Insert to add characters to the front of values, e.g. to add '0x' to hexadecimal values.


See also

Video: How to convert base