Hi
i have the following code to open a txt file
Set wkbTemp = Workbooks.Open(Filename:=FileItem, Format:=6, Delimiter:=",")
When the txt file is open, I am losing the leading zeros in the files e.g 0091 is showing 91 in the cell.
How can i quickly fix it ?
i have the following code to open a txt file
Set wkbTemp = Workbooks.Open(Filename:=FileItem, Format:=6, Delimiter:=",")
When the txt file is open, I am losing the leading zeros in the files e.g 0091 is showing 91 in the cell.
How can i quickly fix it ?