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

  • Thread starter Thread starter papadave
  • Start date Start date
P

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)
 
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.
 
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
 
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.
 
I'm curious, does the apostophe print?
papadave

VenusITN said:
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.
Click to expand...
 
Back
Top