Maybe you can help.... I use excel not for calculation but for maintaining large mailing lists which I usually import from text files.simple question... How do I keepexcel from dropping the leading zero when I import a 4-digit mail code? I need that zero there. I understand that I can format the cells to text and then type thenumber in and the zero stays... But who has time for that? Is there a way to import or open a text file in excel and keep the leading zero?
- 0 Answers
- 443 Views
- I also Faced
- E-Mail Answers
What is it called when two names are combined?
How to split cells in excel shortcut key?
How does goal seek work in excel?
How do you do a vlookup step by step?
What are absolute and relative cell references?
How do I select multiple sheets in excel using the keyboard?
What is the use of scenario manager in excel?
How do I edit a spreadsheet online?
Which function in excel checks whether a condition is true or false?
How can I convert figures into words in excel?
What are some best practices when creating complex models in excel?
What is the formula of percentage in excel?
MS Excel Microsoft 
