Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel, how to limit digits of negative hexadecimal numbers?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel, how to limit digits of negative hexadecimal numbers?
Remember that the hex "digits" 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 Student " wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
excel floating digits error | Excel Discussion (Misc queries) | |||
Excel won't sort numbers correctly | Excel Discussion (Misc queries) | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |