Microsoft Excel Category. - www.developertags.com

I have a list of names and addresses in Excel. Some of the zip codes are in just the regular 5 digit zip code format and some are in the zip + 4 format. I would like to eliminate the additional 4 digits off the zip codes that have them without having to manually delete those numbers from each ce...

Once cells are formatted for zip codes, how do you get the zero as a first digit to be copied into a Word document mail merge?...

Is there a way to change zip codes in a spreadsheet to only display 5 digits?...

Hi, I am a Health care researcher with the following problem: I have a EXCEL spread sheet that has zip codes of various hospitals and the number of beds in each of them. I am interested to find out how many beds there are within say a ten mile radius of any zip code in that list. So for every zi...

Hi, I posted the following in the generic EXCEL forum -- perhaps this is the right forum: I am a Health care researcher with the following problem. I have a EXCEL spread sheet that has zip codes of various hospitals and the number of beds in each of them. I am interested to find out how many bed...

Here is my issue: I have 19k zip codes in excel. They where sent withou the 0's to me. So many of the zip codes are only 3 or 4 digits instea of 5...ex (00235 looks like 235) So I went in and formatted the cells as a zip code digits. Whic visually corrected the field to display all 5 digits...

Ken- Ok, it seems i am back to square one. I have taken all of my zip codes and turned them into 5 digit (22202).. I used a formula to take the last four digits off of all the zips that had it. I then copy and pasted special/values into a new column... now some of the zips line up on the left(th...

I am trying to do a mail merge using an excel data source of addresses. The zip codes appear with zeroes in the data source, but when I merge them to MS Word, the zeroes are dropped. How do I fix this problem?...

Hello, I'm populating each Excel cell with data from a different database that has addresses in it. Zip codes that look like '01234' get interpreted as a number and the 0 gets dropped. How do I get the cell to read and enter the zip code into the cell as a string? Thanks, V...

About half the records show up as a 0 in the zip code field after I merge into Word to create mailing labels. I have reformatted the column to text, tried formatting as special zip code, but stil about half the records merge as 0 zip even though there is a 5 digit zip in the Excel file...this is...

I'm having trouble getting ZIP codes beginning with 0 to stick, even when specifying ZIP code in the format category type. No matter what I do, the initial 0 always gets dropped. Advice? Thanks....

I can't get zip codes beginning with 0 to merge into word. If I format the cell as text it accepts the 0 but it shows in word as only a 0 and omits the other numbers. If I format the cell as a Zip it doesn't take the 0 as a first number. HELP!...

Every time I convert my drop ship lists from .xls files to .csv for import into UPS shipping software, the csv file drops the preceding zero on the east coast zip codes. How do I fix it?...

I am trying to mail merge w/ Word 2000 the names and addresses in my worksheet. When I get to the part to choose the format for the mailing labels, I choose F1, F2, etc. to F6 (which is the zip code column). A few do get there, but the vast majority stop at the state, leaving off the entire zip...

I need my file to be saved in CSV format (to import into another application). When I format the zip codes as Text or Special(zip code), they are correct in XLS format, but when I open the file in CSV format they switch back to general. Any solution? work around? Thanks so much for your help in...

I have a list of 600 so addresses imported from somewhee or another. Several hundred are from new england so the zip codes, which start with a 0, are now displayed as 4 digit numbers. Core Q: All new entries I've been typing ' before the 0 to make the entry text, but how can I easily a...

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?...

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!...

I have a list of 600 so addresses imported from somewhee or another. Several hundred are from new england so the zip codes, which start with a 0, are now displayed as 4 digit numbers. Core Q: All new entries I've been typing ' before the 0 to make the entry text, but how can I easily a...

Microsoft Excel Q&A List

Microsoft Excel

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories

Microsoft Excel