Unable to paste the data from datatable to excel without changing data format

Help Studio
, ,
1

For example - I have a column tracking number(usually have data with leading zero - 0652345) in datatable, while pasting this data into excel, the leading zeros are missing and the value is updated as 652345.

2

Put a single quote before the value. This will cause Excel to treat it as text instead of numeric.