- 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
Hi I have several fields that are linked to a worksheet in another file. The cell in the other worksheet is blank, but puts a zero in the current worksheet. I have tried formatting (does'nt work) , I have tried options and cleared the zero check box. Any suggestions about what I could do to...
- 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...
- Zero in the cell instead of some junk date
Plz let me know how can I get zero in a cell whose format is set to a date format C3 K3 I3 System testing 10-Feb-06 11-Feb-06 e.g IF(OR(C3="Test Planning",C3="Project Planning"),IF(K3<>"",K3,I3),0) But here I get 00-Jan-00 if it dose not match... How can i get a zero displayed -- sunita_sh...