- Zorder doing strange things
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...
- Zoom Selection
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....
- Zip codes that begin with 0
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...
- Zip Code Validation - length =5 or 9
I am setting up a sheet to that will include zip codes. How do I set the validation to only allow a 5 digit or 9 digit value? I've tried a Whole number with: =OR(LEN(B3)=5,LEN(B4)=9) but this doesn't allow anything to be entered. I've been searching thru the group for 2 days, and...
- ZIP CODE FORMATTING
I HAVE A DATA BASE WITH THE ! ICON REFERENCE ON SOME OF MY ZIP CODE ENTRIES. IT SAYS THAT "THE NUMBER IN THIS CELL IS FORMATTED AS TEXT OR PRECEDED BY AN APOSTROPHE." HOW DO I FORMAT THE ZIP CODES SO THAT THEY ARE ALL THE SAME?SOME ENTRIES DO NOT HAVE THIS DISCLAIMER. THANKS, VICTOR...
- Zeros on the left
Hi, have check number such as 00356. When entered in a cell and pressing enter, it shows 356. How can we keep it shown as 00356? and what cell format is necessary if any?...