Managing leading zeroes in zip, numerical, and text codes


show more Managing leading zeroes in zip, numerical, and text codes provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data show less
please wait ...

Managing leading zeroes in zip, numerical, and text codes

If you use numeric codes that begin with zeros--and of course some ZIP codes do begin with zero-- you need to be able to see and retain those zeros. There are a couple techniques we want to take a look at there. First of all, in Column A, let's imagine that someone typed the ZIP codes, maybe looking at a sheet of paper, heads down, just typing the zeros where appropriate, but the zeros actually didn't appear. So you can imagine, in Cell A5, for example, whoever was typing this probably typed 02299, as I'm typing here. So what happens though when we press Enter? The zero doesn't appear there.

Now we wouldn't have to go through any shenanigans or anything unusual here; simply format Column A--right- click > Format Cells. And ideally, you do this before you put the data in--it makes a bit more sense--and you'll see correct entries as we go. There is a special category on the Number tab in Format Cells. It's called Special. And we got two ZIP code entries: Zip Code,...

Managing leading zeroes in zip, numerical, and text codes
Video duration: 5m 43s 1h 28m Appropriate for all

Viewers:

Managing leading zeroes in zip, numerical, and text codes provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data

Subjects:
Business IT
Software:
Excel
Author:
please wait ...