:HEX2DEC function converts hexadecimal to decimal-Table skills免费ppt模版下载-道格办公

HEX2DEC function converts hexadecimal to decimal

Picture and text skills
Case

Convert hexadecimal number to decimal number.

Syntax
HEX2DEC(number)
Number The hexadecimal number to be converted. The number of digits in the parameter number cannot exceed 10 digits (40-bit binary), the highest bit is the sign bit, and the remaining 39bits

is a digit. Negative numbers are represented by the binary number's complement.

Description
If the parameter Number is not a legal hexadecimal number, HEC2DEC returns the error value #NUM!.

In order to facilitate the calculation of statistics in life and work, we often Convert values in different bases into the same base.
So how to quickly convert hexadecimal values to decimal?
The HEX2DEC function is involved here.

￭Open the WPS 2019 EXCEL table. We need to convert all these hexadecimal values into decimal.
Place the cursor at (C4) and click Insert Function-Project-HEX2DEC Function.
A dialog box will pop up with one parameter.
"Hex number" is the hexadecimal number that needs to be converted.

￭Enter (B4) in "Hexadecimal Number" and click OK to get the conversion result.
Place the cursor in the lower right corner of (C4) and pull down to fill in the formula in a + shape.
You can convert all hexadecimal numbers into decimal numbers.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/HEX2DEC-han-shu-shi-liu-jin-zhi-zhuan-huan-shi-jin-zhi.html