Как пользоваться функцией DEC2HEX в Excel
| Русский | Английский |
|---|---|
| ДЕС.В.ШЕСТН | DEC2HEX |
The DEC2HEX function in Excel and Google Sheets converts a decimal number to a hexadecimal number.
Syntax
The syntax for the DEC2HEX function is:
DEC2HEX(number, [places])- number — Required. The decimal number you want to convert to hexadecimal.
- places — Optional. Specifies the minimum number of characters for the returned string. If omitted, the function returns the hexadecimal number without leading zeros.
Examples of Use
Example 1:
Converting the decimal number 255 to a hexadecimal number:
| Decimal Number | Hexadecimal Number |
|---|---|
| 255 | =DEC2HEX(255) |
Result: FF
Example 2:
Converting the decimal number 1234 to a hexadecimal number with a minimum string length of 4 characters:
| Decimal Number | Hexadecimal Number |
|---|---|
| 1234 | =DEC2HEX(1234, 4) |
Result: 04D2
Example 3:
Converting a decimal number from cell A1 to a hexadecimal number:
| A | B |
|---|---|
| Decimal Number | Hexadecimal Number |
| 357 | =DEC2HEX(A1) |
Using the DEC2HEX function, you can easily work with hexadecimal numbers in Excel and Google Sheets.
Больше информации: https://support.microsoft.com/ru-ru/office/функция-дес-в-шестн-6344ee8b-b6b5-4c6a-a672-f64666704619