Duplicating Tasks also duplicates the Task ID

[LEGGO]

@Phil_Seeman when testing this I noticed that IF one was to edit/double-click a value in the Task ID column the issue gets re-introduced and the 16th character as a zero reappears. The fix to this would be to change the format of this column to be TEXT instead of GENERAL.

Another way to do this, if you have access to Power Query Tools, is described in this post:

@LEGGO

Once you have successfully connected your Asana data in MS Excel, right click on the query from the Queries & Connections pane as shown below. Select the “edit” option which will open the Power Query Editor.

If this pane isn’t shown initially you can view it by selecting “Data” (from the MS Ribbon) then “Queries & Connections”

Once the Power Query Editor has launched, change the portion of the table formula highlighted in yellow below to read as show. This will convert the raw data from Asana for the Task ID so that it allows for all 16 characters to be shown.