Input a list of eight bytes in the excel spreadsheet hexadecimal number, now want to convert it to a decimal, use function HEX2DEC, but negative hexadecimal number or a decimal number is converted to a positive, if make up in front of the negative "ff", to fill up 40 bits, displayed a negative decimal number correctly, but I have a larger amount of data, but also is negative, if a a transformation is too much trouble, you have what good method?

CodePudding user response:

=REPT (" F ", 40 - LEN (A1) & amp; A1 

If less than 40 A1, fill in front F