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?
Debbie Love wrote: > 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? Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
Can anybody explain what's going on here ? Put two listboxes and two commandbuttons on a form and partially overlap the two listboxes. The code below should alternately bring to the front and then to the rear Listbox2. Private Sub CommandButton1_Click() ListBox2.ZOrder (0) End Sub Private S...
Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like t...
Zoom is on my Toolbar. I click the arrow and a menu drops down. One of the items is Selection. When I click Selection I get 400%. I want 92% not 400%. How do I do it? I've Excel 97 with Win XP....
Hi all, Need to know is it possible to Zoom all sheets in a workbook at once, say have all appear at 200% or whatever, when I go to the Zoom control not just the sheet I am working on. Cheers, Andy....
I have number of worksheets in the one workbook all currently sitting at zoom 127% - I want to konw if there is away I can changed the zoom display all on sheets at once to 75%...
I need to change Zulu time back 1 hour due to the daylight savings time. I have a format I need to follow, which is example ?P 04:45Z? Where the P needs to remain because it signifies proposed, and the Z needs to remain, because it signifies Zulu and the time 04:45 needs to be made 03:45 while p...
Whenever a user opens an Excel Spreadsheet the sheet automatically zooms to 400%. This happens when the user is connected to a projector or second monitor. I have updated the display driver and downloaded all MS Office Updates. Nothing else seems to be having issues except Excel and Word. The on...
My work sheet only prints on the first half of the page width? Setup and margins don't seem to work so I can print larger. My worksheet prints out 4" wide and 2" deep. I want it to print the full page' ANy help is appreciated...
Adjusting the zoom level while viewing my spreadsheet appears to affect the formatting of the text in certain cells. For example, several of my cells have three lines of text, and when the zoom level is reduced, only the bottom two lines of text are visible. It appears as though the visible size...
I would like to know if it is possible to open a workshhet alway to the same same zoom level (i.e 94%) no matter if i am closing it to a different one (i.e 105%)...
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...
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...