Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Quickly convert between different number systems without using formula in Excel

With the Conversion of Number Systems utility of Kutools for Excel, it is easy to convert between different number systems without using any formulas. For example, you can easily convert binary to hex, octal to decimal, decimal to hex, ascii to hex and so on with only several clicks in Excel.

Convert binary to hex or vice versa without using formula

Convert octal to decimal or vice versa without using formula

Convert decimal to hex or vice versa without using formula

Convert ascii to hex or vice versa without using formula


Click Kutools > Content > Conversion of Number Systems. See screenshots:

shot convert between number system 1


Convert binary to hex or vice versa without using formula

For converting binary to hex, you need to do as follows.

1. Select the range with binary values you need to convert to hex, and then apply the utility by clicking Kutools > Content > Conversion of Number Systems.

2. In the Conversion of Number Systems dialog box, please select Binary in the first Conversion type box, select Hexadecimal in the second box, and then click the OK button. See screenshot:

Note: For converting hex to binary, please exchange the options by just clicking button as above screenshot shown.

3. Then a Kutools for Excel dialog box pops up to tell you how many cells have been converted, please click the OK button.

Now all binary values in selected range are converted to hex immediately as below screenshot shown.


Convert octal to decimal or vice versa without using formula

Also, you can easily convert octal to decimal or vice versa with this utility.

1. Select the range with octal values you need to convert to decimal, and then apply the utility by clicking Kutools > Content > Conversion of Number Systems.

2. In the Conversion of Number Systems dialog box, please select Octal in the first Conversion type box, select Decimal in the second box, and then click the OK button. See screenshot:

Note: For converting decimal to octal, please exchange the options in the Conversion of Number Systems dialog as you need.

3. Then a Kutools for Excel dialog box pops up to tell you how many cells have been converted, please click the OK button.

You can see all octal values in selected range are converted to decimal immediately. See screenshot:


Convert decimal to hex or vice versa without using formula

This section is talking about converting decimal to hex or vice versa with the Conversion of Number Systems utility of Kutools for Excel.

1. Select the range with decimal values you need to convert to hex, and then click Kutools > Content > Conversion of Number Systems to apply the utility.

2. In the Conversion of Number Systems dialog box, please select Decimal in the first Conversion type box, select Hexadecimal in the second box, and then click the OK button. See screenshot:

Note: For converting hex to decimal, you need to select Hexadecimal in the first Conversion type box, and select Decimal in the second box. Or just click button to exchange the options.

3. Then a Kutools for Excel dialog box pops up to tell you how many cells have been converted, please click the OK button.

Then all decimal values in selected range are converted to hex as below screenshot shown.


Convert ascii to hex or vice versa without using formula

For converting ascii character to hex or vice versa, please do as follows.

1. Select the range with ascii characters you need to convert to hex, then click Kutools > Content > Conversion of Number Systems to apply the utility.

2. In the Conversion of Number Systems dialog box, please select ASCII Characters in the first Conversion type box, select Hexadecimal in the second box, and then click the OK button. See screenshot:

Note: For converting hex to decimal, please select Hexadecimal in the first Conversion type box, and select ASCII Characters in the second box.

3. Then a Kutools for Excel dialog box pops up to tell you how many cells have been converted, please click the OK button.

Now all ascii characters in selected range are converted to hex. See screenshot:


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.