The 0 is dropped in zip codes beginning w/zero (Excell)

[papadave]

Whenever I enter a zip code or birthdate (01/02 1943) begining with a zero in
Excell, the zero is dropped when I print a list. How can I ge the zero to
display at the beginning in these instances.
David (a dunce, I guess)

 

[David Biddulph]

Either:
Format as text before you put the number in, or
Precede the number by an apostrophe, or
For date:
Put the date in as 01/02/1943 and format as dd/mm/yyyy (or mm/dd/yyyy as
appropriate), or
For zip code:
Format cell as zip code, or
Format as 00000 if you are loking for 5 digits.

 

[papadave]

Thank you David. I fomatted the zip code column as text as that is the only
one that would work. Now, why couldn't I have thought of that?
papadave

 

[VenusITN]

I just put in a ' when I want to do an individual item as text. So '01/01/07
will make that text also. Handy if it is only done here and there.

 

[papadave]

I'm curious, does the apostophe print?
papadave

I just put in a ' when I want to do an individual item as text. So '01/01/07
will make that text also. Handy if it is only done here and there.

 

[VenusITN]

Dave,

Nope. It is an Excel command, so you never see it in that context.

Good luck!