- 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?...
- Zeros in calculated items in pivot tables
I have a very simple calculated item in a time dimension of a pivot table (Q1 = Jan+Feb+Mar). However because a lot of the data is has null values my calculated item returns a zero value which increases the number of rows in my pivot table by 10 times. Anyone know how I can either not show these...
- Zeros
How can I preserve leading zeros in a cell? I'm entering equipment serial numbers in cells, but any leading zeros are not displayed. I do have the Zero Values box checked in Options. Thanks in advance. -Hank -- Posted via a free Usenet account from http://www.teranews.com...
- zeroes being truncated
Hi, I have a tab delimited file that has products that I import into design software and I am having a problem opening it in excel because the product codes sometimes lead with zeroes. How can I open the file without getting rid of the zeroes? I can open the file with notepad and see all the pro...
- Yet more validation ... challenges!
Hello All Bob/Rick - are you there?! Having done some more testing with the validations that you have each helped me with, I have found a couple of problems. The code that I have for validating times works fine except that, having entered an invalid time, the invalid time is retained after the e...
- Yet another userform combobox question
Hi Can anyone tell me how, when I select an option in a drop down menu in a userform combobox, I can code it to shrink back down again once the selection is made. At the moment it just hangs there like a lemon until I click on it again...