I humbly bow to your suggestion. I tried this again today and it worked.
(No shock to you I am sure.) Not sure what happened yesterday. Anyway thanks
for the tip. I will remember that. ;)

"Duke Carey" wrote:

If I run this query in SQL Server's Query Analyzer

select 6506508818150199801 as Answer

and copy the result into Excel *AFTER* first formatting the target cell as
Text, Excel accepts it as text & does not change it.

How are you pasting it?


"Candyman" wrote:

When I do that the number comes out as an exponential. It is 19 digits long.
To get rid of the exponential I have to convert to a number... Then it shows
as rounded again! Hmmm

"Duke Carey" wrote:

Don't change your query, but before pasting format the cells in Excel as text

"Candyman" wrote:

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.