View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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)