Excel Help and Problems

[lubaby]

Won't that print as '08701? That doesn't look right...

No. The ' tells Excel to format the field as text and save exactly what you type in. Nothing is noticeable when you print.
You can always do Print Preview to see how it will look once printed.

[chucksterace]

No. The ' tells Excel to format the field as text and save exactly what you type in. Nothing is noticeable when you print.
You can always do Print Preview to see how it will look once printed.

Or just to print to PDF and see also

[churnbabychurn]

Or use the special zip code format!
http://office.microsoft.com/en-us/excel-help/display-numbers-as-postal-codes-HP001216509.aspx

[katherine123]

Or use the special zip code format!
http://office.microsoft.com/en-us/excel-help/display-numbers-as-postal-codes-HP001216509.aspx

 I tried that, it didn't work.

[churnbabychurn]

I tried that, it didn't work.

It should..
ETA it does

[yitzf]

It should..
ETA it does

I vaguely remember it not working when I mail merged it in word, it would lose the 0. What I did was =IF(LEN(A1)=4,"08701",A1) where A1 is the zip code, and just copied it all the way down the list. Obviously only works if the only zip starting with a 0 in your list is Lakewood.

[bubbles]

I vaguely remember it not working when I mail merged it in word, it would lose the 0. What I did was =IF(LEN(A1)=4,"08701",A1) where A1 is the zip code, and just copied it all the way down the list. Obviously only works if the only zip starting with a 0 in your list is Lakewood.

I don't think it's necessary to do it this way, but if you want...
=IF(LEN(A1)=4,CONCATENATE("0",A1),A1)

[churnbabychurn]

how does adding a leading zero through a formula prevent it from getting lost due to a number format issue?

[etech0]

I vaguely remember it not working when I mail merged it in word, it would lose the 0. What I did was =IF(LEN(A1)=4,"08701",A1) where A1 is the zip code, and just copied it all the way down the list. Obviously only works if the only zip starting with a 0 in your list is Lakewood.

to work for other zip codes you could change it to
=IF(LEN(A1)=4,"0"&A1,A1)

[etech0]

how does adding a leading zero through a formula prevent it from getting lost due to a number format issue?

but you're right

[churnbabychurn]

The problem is with a word mail merge, nothing wrong with excel's zip code format. In word there should be an option to format the field as zip also

[yitzf]

I don't think it's necessary to do it this way, but if you want...
=IF(LEN(A1)=4,CONCATENATE("0",A1),A1)

Now that you mention it, I think that's what I did. (I know I wasn't so tied down to lakewood  )

[jack12]

Funny how this issue only comes up with lakewood

All New Jersey zip codes start with a 0

[chucksterace]

All New Jersey zip codes start with a 0

And why would no one mention that earlier.

[etech0]

And why would no one mention that earlier.

That's the funny part...

[AnonymousUser]

And why would no one mention that earlier.

You mean there are places in NJ besides Lakewood???

[chucksterace]

You mean there are places in NJ besides Lakewood???

Nope.

[etech0]

Nope.

Sorry guys, but I'm moving to Passaic in less than a month...

[jack12]

All New Jersey zip codes start with a 0

Other states do too. From Wikipedia: 0 = Connecticut (CT), Massachusetts (MA), Maine (ME), New Hampshire (NH), New Jersey (NJ), Puerto Rico (PR), Rhode Island (RI), Vermont (VT), Virgin Islands (VI), Army Post Office Europe (AE), Fleet Post Office Europe (AE)

[churnbabychurn]

Whats an easy way to remove every second row of data?