I. Intro
The DEC2OCT function converts a decimal number to an octal number.
II. About the function
- Formula: =DEC2OCT(decimal_number,[places])
- Parameters:
- decimal_number (required): The decimal value that you want to convert to an octal number (string representation).
- places (optional): The number of significant figures to return.
- Example: =DEC2OCT(100,8)
III. Steps
Use the DEC2OCT function
- Select a cell and click Formulas on the toolbar, then select Engineering > DEC2OCT. You can also directly enter =DEC2OCT in a cell.
- Enter the parameters in the cell. For example: =DEC2OCT(A3).
- Press Enter to get the result, which is 4 in this example.
- Drag the + icon in the lower-right corner of the cell to apply the formula to other cells.
250px|700px|reset
Delete the DEC2OCT function
Select the cell with the DEC2OCT function and press Delete.