How to deal with leading zeros in Excel and preventing them from being deleted


This really annoys me about excel. What happens when we copy and paste this data from notepad into Excel?

2013-08-22_0102

 

I don’t know why, but Excel insists that we do not need the zeros!

2013-08-22_0103

 

However, we do indeed want the zeros! What happens if we format the column as zip code thinking this will surely solve the problem!

2013-08-22_0104

 

Unfortunately, it does not! Let’s try something else. Let’s save that initial text file and follow these steps:

  1. Let’s import this text file using the “Get External Data” feature:
    2013-08-22_0107
  2. Double click on the file
  3. At this point we are at the Text Import Wizard:
    2013-08-22_0109
  4. If your source file has only one column as we have in this example, you may click next right through until here. Make sure to do two things – select text and click on the text column so that it’s highlighted as seen below:
    2013-08-22_0111
  5. Now finish…

View original post 18 more words