| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Unwanted rounding of large number
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Master invoice number | Excel Worksheet Functions | |||
| Function for Rounding of Number | Excel Worksheet Functions | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Threaded Mode
