| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting hex values to negative numbers
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
converting hex values to negative numbers
Michael
Use the HEX2DEC function. To use this you will need to load the Analysis ToolPak via ToolsAdd-Ins... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Michael_Braganza" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
converting hex values to negative numbers
One problem with that is that if you have fewer than 10 characters in your
HEX number it will regard it as positive, so you may want to pad out with leading Fs, with something like =HEX2DEC(REPT("F",(LEFT(A1)="8")*(10-LEN(A1)))&A1) but of course you'll have to remember to include leading zeroes in your input data if there are any. -- David Biddulph "Nick Hodge" wrote in message ... Michael Use the HEX2DEC function. To use this you will need to load the Analysis ToolPak via ToolsAdd-Ins... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Michael_Braganza" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicate numbers in column a and diferent values in b | Excel Worksheet Functions | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| Converting negative/positive numbers to a CSV (Comma-delimited .TX | Excel Worksheet Functions | |||
| Min values in a list of numbers | Excel Worksheet Functions | |||
| Compare Negative & Positive Numbers | New Users to Excel | |||
Hybrid Mode
