Number System Conversion

5 lessons in order

Learn how to convert decimal values to hexadecimal in Excel using the DEC2HEX function or custom formulas for colon-separated hex formats.

Learn how to convert binary to decimal in Excel using BIN2DEC, DECIMAL, SUMPRODUCT formulas, and custom VBA functions step by step.

Learn how to convert decimal to binary in Excel using DEC2BIN, BASE, and IF functions to handle large values and negative numbers easily.

Learn how to convert hex to decimal in Excel using HEX2DEC, the DECIMAL function, or a custom VBA function for advanced use.

Learn how to convert hex to binary values in Excel using the HEX2BIN function and VBA for handling longer hex strings.