Converts hexadecimal numbers to octal numbers.
grammar
HEX2OCT(number, [places])
The HEX2OCT function syntax has the following parameters:
Number required. The hexadecimal number to convert.
Number cannot contain more than 10 characters.
The highest bit of Number is the sign bit.
The remaining 39 bits are quantity bits. Negative numbers are represented by binary complement notation.
Places is optional. The number of characters to use.
If places are omitted, HEX2OCT uses the minimum number of characters necessary.
Places can be used to prefix the returned value with 0 (zero).
Instructions
If the argument Number is negative, the HEX2OCT function ignores places and returns a 10-digit octal number.
If Number is negative, it cannot be less than FFE0000000. If Number is positive, it cannot be greater than 1FFFFFFF.
If number is not a valid hexadecimal number, HEX2OCT returns #NUM! Error value.
If HEX2OCT requires more than one character, it will return #NUM! Error value.
If places is not an integer, round the truncation.
If HEX2OCT is non-numeric, #VALUE! Is returned. Error value.
If the number of bits is negative, HEX2OCT returns #NUM! .
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/