Keep leading zeroes after Text to Columns

[megera716]

I have a comma-separated .txt file of employee bank account information. When I open in Excel and run Text to Columns, it removes the leading zeroes from bank account numbers that have them. Even in the formula bar if I click on one of the cells that I know was an account number with a leading zero, the zero is gone (but it was there in the .txt file before I separated it). I also have the file in an Excel CSV where it's already separated, but still don't have the leading zero.

I have tried both the "general" and "text" column data formats in Step 3 of the wizard but both give the same result.

Help?

 

[Fluff]

Are you importing the data via the data tab?
If so when you get the import wizard, select the column with the account numbers & then select text

 

[megera716]

Thanks, I didn't notice that the column with the account numbers wasn't selected as the one I was formatting to text! I thought it would change the whole thing. This worked perfectly, thank you so much!!

 

[Fluff]

Glad to help & thanks for the feedback