How do I convert integer to 4-digit hex string?
<p>I need to convert a 2-byte signed integer into a string of it's hex equivalent, but I need the string to be 4 characters.  I've tried the Hex() function but when I convert 0 or say, 10, the result is 0 or A.  I need the result to be 0000 or 000A.  Any tips or advice?</p>