In the past I was able down load a number from a data file (credit card
transaction numbers for internal audit part of my job) I would have to change
the number to a value for the vlookup to work properly. 15 character eg
999563256923654 would be translated to come out as 9.99563E+14 WHEN CONVERTED
TO A VALUE.
The problem I have now that the transaction numbers have increased one
digit to 16 characters transferring it to a value is rounding up or down the
last number to eg 10000000000001656 conveting to a value (1e+16) and when
hover over the cell would find that the last number (6) has been rounded up
to 0 this is very frustrating as it is not aligning with the right credit
card transaction. Can someone please explain why this is happening. Is it
something in my settings in excel. Your help will be appreciated. Arthur