ExcelBanter - converting hex values to negative numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - converting hex values to negative numbers (https://www.excelbanter.com/excel-discussion-misc-queries/122158-converting-hex-values-negative-numbers.html)

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 ...

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 ...