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.
Put a single quote before the value. This will cause Excel to treat it as text instead of numeric.