Join Dennis Taylor for an in-depth discussion in this video Add leading zeroes: Zip codes, other numerical codes, and text codes, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] When you get data…that should've had leading zeroes but doesn't,…it poses some problems and some different issues occur.…We need to clean up the data for…multiple reasons on this worksheet here.…Let's focus on Column A, first of all.…This is a common problem.…Someone entered zip codes here,…maybe it was just essentially…looking at a sheet of paper, typing an entry,…pressing Enter, not looking up,…and here that person typed 02299, and here was 00766.…What happens to the leading zeroes?…Well they're not there.…These are in so-called general format,…no special formatting was applied.…
But a special format could've been applied.…I'm going to right click Column A,…go right to Format Cells,…and on the Number tab, the Category, Special…has two variations on zip codes.…The five digit, the first one is the one we want to use,…we'll click OK, watch those entries in Column A,…they now have leading zeroes.…And by the way, that means when you are typing these,…you don't need to type the leading zeroes,…that makes it even easier.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes