Getting started with excelExcel rounding and precisionDATEDIF functionVLOOKUPMATCH functionArray formulasCounting unique cellsCreate Connection to other Excel FilesExcel best practiceSUMPRODUCT functionIndex Match for ExcelCell FormattingBase ConversionExcel specifications and limitsAn easy process to convert Monthly to Quarterly data in Excel
Base Conversion
Remarks:
Note that there are no leading 0 or 0x in the functions.
Base Conversion
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.
Contributors
Topic Id: 10708
Example Ids: 32129
This site is not affiliated with any of the contributors.