Leading Zeros

[cande466]

I'm sorry if this is basic for this room but I am ready to slam my head through a wall. I have received an attachment of a .csv file from a client and one of the fields is a tenant ID number that sometimes begins with 1 or more zeros. When I open the attachment it is opening in Excel and dropping the zeros. How can I open that up and keep the zeros. I need those leading zeros. Again my apologies if this is too basic for all of you.

[vlady]

Data>Import Data->select the .csv ->--From the 'Text Import Wizard' -> select 'Delimited'
-select all the columns which you would want to be displayed as text. -> 'Column Data format' select Text

[cande466]

Thanks so much Vlady. I knew it must be something simple. Worked perfectly!

[abousetta]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.