excel Base Conversion Base Conversion
Example
with the number 100 in cell A1, the results of these calculations
=DEC2BIN(A1)
=DEC2OCT(A1)
=DEC2HEX(A1)
=BIN2DEC(A1)
=OCT2DEC(A1)
=HEX2DEC(A1)
is
1100100
144
64
4
64
256
note that the first 3 functions are left justified, as they are strings, and the last 3 are right justified as they are numeric.
