RE: [sqr-users] Excel cell limitation

["the dragon" <ceprn@hotmail.com>]

While this is an EXCEL issue and not an SQR issue - my guess is this, based 
upon the following experience....  I think excel is interpretting the 16 
digit number as a credit card (since credit cards are 16 digits long) and is 
using the 0 as a security feature...  The reason I think this may be 
happening is that I was using excel for tracking my credit card information 
in case the cards were ever stolen, and I noticed this happening; the last 
digit being replaced as a 0.

I am not certain how to fix it - perhaps treating it like a character or 
doing something manual when you open the file...

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

It is impossible to defeat an ignorant man in argument.

William G. McAdoo

----Original Message Follows----

Hello all:

   I am new to this forum....
   My sqr program is producing a CSV file report ... in one of the field, a 
16 digit number is inserted ... but EXCEL truncates the last digit and puts 
a 0 in its place ... for instance if my sqr program inserts a value of 
1234567890123456 in the csv field, then the excel makes it as 
"1234567890123450"  so, the last digit is replaced with a 0 ... does any one 
know how to resolve this issue?
   Thanks in advance.
   Vg

_________________________________________________________________
Try Search Survival Kits: Fix up your home and better handle your cash with 
Live Search! 
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmtagline


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users