keeping leading zeros when import from txt file

New Contributor

Hi i am trying to import into excel from a text file. I need to keep the leading zero

2 Replies


During the import, choose to Transform then set the data type on the column to Text as seen below:




Thanks i will try that.