Duplicating Tasks also duplicates the Task ID

English Forum Tips and Tricks
,
4

@Charles_Haynie,

I did figure out a way to do it - not sure if this is the only way but it worked.

Instead of just double-clicking the CSV to open it in Excel which causes Excel to assume the ID column is numeric, which causes it to lose the last digit because it can’t handle numeric values that large, do this:

  1. Open Excel, select New for a new blank workbook.
  2. Go to the Data tab; select Get & Transform Data > From Text/CSV
  3. Browse to and select your exported CSV file and click Import.
  4. In the resulting window, drop down Data Type Detection and select Do not detect data types. (This step is the key to the whole thing.)
  5. Click Load. Voila - your IDs are present in their entirety.
1 Like