- 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...
- 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...
- Yet another macro...
Hi everybody,I know it can sound trivial, but I cant solve this problem:I'm using in an excel macro: Range(RangeFrom).Copy Range(RangeTo).PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=FalseThe fact is that I would like to trim blank spaces th...