View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default trying to insert a 0 in front of zipcode

One of these
1) format the cells with custom format 00000
2) format the cells with Special / Zip Codes
3) format the cells as Text
4) begin all zip codes with an single quote (apostrophe) (will not show in
cell nor will it be printed)

1 and 2 can be applied retroactively - ie to existing entries
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"hlander9" wrote in message
...
Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels
with...about
700 of them but the problem is my zipcode column there needs to be a zero
in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
thanks
Greg