ron | Fri, 23 May 2008 04:01:00 GMT |
tom | Fri, 23 May 2008 04:02:00 GMT |
jamest | Fri, 23 May 2008 04:03:00 GMT |
ron | Fri, 23 May 2008 04:04:00 GMT |
I want to enter 5 digit zipcode in cell a1, and want the first three digits of that zipcode to appear in cell a2 thanks...
I create text files (csv) from Informix 4gl and I often need to send zipcodes. When csv files open in excel, you lose the leading 0 for states like CT, NJ, and MA. Is there an ascii character to put in front of zip? I can't depend on users to change the formatting of the cells....
I have an address data base in excel. Zip codes with the plus 4 (77777-1234) show as 0 when I do a mail merge for address labels using word. I have tried reformatting the zip code cells to zip + 4 and serveral other formats and nothing works. Help please and thank you...
I am using Excel 2002 and I am trying to do a mail merge for address labels. In my "zip code" column, I have a few that begin with 0. I have formatted the column as a "zip code" column, but when I do the merge, the first 0 drops off. How do I get the first 0 to stay' Thanks -- Ray Remove NO...
I have an excel spreadsheet that I need to convert to a .csv to import. One of the columns is the zip code, including codes that start with 0. However, whenever I convert it to .csv, it strips out the first 0 of the zip code, thus leaving a 4 digit code. Is there a way to fix this? Thanks!...
my code currently saves a file and then attaches it to an e-mail. is it possible to get it to zip the file after it has been saved and then attach the zipped folder?...
my code currently saves a file and then attaches it to an e-mail. is itpossible to get it to zip the file after it has been saved and then attachthe zipped folder?...
I have several excel files that I zip together. Recently another user added, and then removed, security to the excel files. Now, when I zip them all together, instead of being 3 or 4 mb, the zipped file is 13 mb. I need to know how I can reduce the zip file back to the original size, if anyone c...
I have a column of zips. Some have a leading zero. I have first fixed the column cellproperties to be GENERAL, and saved the file. Then I reformatted using CUSTOM 00000, and saved the file. Next I go to WORD, set up a mail merge, and then edit recipents, and the leading zero has disappeared, lea...
Okay, I'll try to keep this fairly striaght forward, but let me explai the why before I explain the what... I am in charge of a marketing mailing project that covers all of Nort America. My company has broken NA up into 5 zones, using zipcodes a their guide... What I've been doing over...
When I do mailmerge for labels with Word, a few of my zipcodes are there (randomly) but most are not. What am I doing wrong? Also, sometimes I get to choose F1, F2, etc. for the fields, and sometimes I get First name, Last name, etc. How do I get that to be consistent each time I merge? This is...
I'm trying to email an excel spreadsheet to a printing shop for printig. The file is 1.88MB in size and will not deliver the email due to the file size. My question, how can I either zip or compress this file so I will be able to email it? Thanks in advance for your help. Cal...
Do not what outlook to zip my file?...
I can format the cell as text in Excel and the zeros show up and print fine, but when I mail merge into WORD, I get a zero ONLY as a zipcode. Frustrating. I need to print labels by Friday. WHat do I do?...
When doing a mail merge from excel to word zip codes starting with 0 (zero) drop the first number "0" from the address. ie zip code 01560 prints out as 1560. How do I get all 5 numbers to show?...