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

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)

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

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.
--
David Biddulph

"papadave" wrote in message
...
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)

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

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

"David Biddulph" wrote:

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.
--
David Biddulph

"papadave" wrote in message
...
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)

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

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" wrote:

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

"David Biddulph" wrote:

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.
--
David Biddulph

"papadave" wrote in message
...
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)

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

I'm curious, does the apostophe print?
papadave

"VenusITN" wrote:

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" wrote:

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

"David Biddulph" wrote:

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.
--
David Biddulph

"papadave" wrote in message
...
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)

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

Dave,

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

Good luck!

"papadave" wrote:

I'm curious, does the apostophe print?
papadave

"VenusITN" wrote:

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" wrote:

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

"David Biddulph" wrote:

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.
--
David Biddulph

"papadave" wrote in message
...
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)