| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trying to insert a 0 in front of zipcode
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trying to insert a 0 in front of zipcode
You would be much better of using Word for the mailmerge with Excel as the
source. You could do it in Excel alone but you can waste a lot of paper and labels with trial and error printing. See these sites for help on mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm Note on the leading zeros. If you simply format to show leading zeros, these will not show up in Word's mailmerge. You must re-format in Word using Word's field codes. You may want to actually add the zeros in Excel. In an adjacent helper column enter =TEXT(cellref,"00000") where cellref is first cell in your ZIP CODE column Drag/copy down as far as you need. Copy that helper column and Paste SpecialValues on top of your original ZIP CODE column. Gord Dibben MS Excel MVP On Tue, 12 Jan 2010 07:22:01 -0800, hlander9 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS | Excel Worksheet Functions | |||
| Insert symbol in front of value | Excel Discussion (Misc queries) | |||
| How to insert zipcode(number) in one cell when city(text) put in another | Excel Discussion (Misc queries) | |||
| INSERT THE SAME WORD IN FRONT OF EACH ROW | Excel Discussion (Misc queries) | |||
| how do I insert an ' in front of many rows of numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
