I run a query against DB2 and receive the complete number (a number feild).
But when i cut and paste into Excel the values change. Why?
Excel is rounding the ID number:
6506508818150199801 to 6506508818150200000
6506508804141199801 to 6506508804141200000

my work around was a modified statement in the SQL:
'`' || cast (ACCT.CUST_ACCT_ID as char(20)) CUST_ACCT_CHAR_ID which results
in `6506508818150199801. This pastes into Excel without rounding, but the "`"
is still there.