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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MS Excel Microsoft Interview Questions

How do I jump to the first tab in excel?

0 Answers  


How do I create a formula for conditional formatting in excel?

0 Answers  


How many sheets are there in ms excel 2007?

0 Answers  


What are the formulas and functions of ms excel?

0 Answers  


How do I create a shared excel file?

0 Answers  


How do I create a bubble chart in excel with multiple series?

0 Answers  


Is it possible to sum up the rows and column number in the excel sheet?

0 Answers  


What is the run command for excel?

0 Answers  


How do I open excel 2010 in safe mode?

0 Answers  


How do you use the left function?

0 Answers  


Where is solver in excel?

0 Answers  


How do I format conditional formatting in excel?

0 Answers  


Categories