close
how does one limit the number of digits displayed in a negative hexadecimal
number?
e.g., instead of the default 10 digits, somethimes i'd like to have only 3
digits, other times 4.
Remember that the hex quot;digitsquot; are just a string representing the number:In A1 put -700
in B1 put =DEC2HEX(A1) and you will see FFFFFFFD44
if you want the upper half then use =RIGHT(HEX2DECMAL(A1),4)
if you want the lower half then use =LEFT(HEX2DECMAL(A1),4)
--
Gary''s Studentquot; wrote:
gt; how does one limit the number of digits displayed in a negative hexadecimal
gt; number?
gt;
gt; e.g., instead of the default 10 digits, somethimes i'd like to have only 3
gt; digits, other times 4.
全站熱搜
留言列表
