larger number support
Excel is still stuck in the 1990's as far as number support. Numbers greater than 15 digits lose subsequent digits. DEC2HEX, HEX2DEC and the whole family of related functions can't handle larger values (over ~5bytes). I find that I have to use Windows Calculator to do these more complex values -- it's hard when the free calculator has greater range than what should be a premiere calculation tool.
any fix for this ?
we see this same issue with our data, after the 15th digit excel lose numbers, and use only zeros.