keeping leading zeros when import from txt file

Copper Contributor

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

2 Replies

@Derbyd_151 

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

 

Patrick2788_0-1651170148845.png

 

Thanks i will try that.