I saw a couple of other posts regarding the problem with the zeros not displaying properly in zip code entries. I'm able to see the zeros, but when i try to...

I saw a couple of other posts regarding the problem with the zeros not displaying properly in zip code entries. I'm able to see the zeros, but when i try to...

frank -- your message was unavailable....do you have any answer to the zip code question

I have a working LOOKUP function in a spreadsheet referencing another page, but when I copy it, or even retype it in the other rows, it returns the #N/A...

In my current worksheet I have created links to a second worksheet in the same file. I notice that Excel throws the value of zero in my current worksheet even...

I'm importing some data in which a number of the cells contain numbers that begin with mulitple zeroes, but excel is autmoatically deleting those zeroes. ...

I added a calculated item in my pivot table. It generated lots of lines with zeros that did not exist before (indeed the result of my calculation is zero since...

I was moving along very well gathering information form several other worksheets in my workbook by using the = sign to display text from the worksheets into...

Why, in the result of a formula, does "0" sometimes appear as 0.00, (0.00), or -? The formula and the formatting on all cells is the same and is a simple...

I'm trying to display zeros as dashes. It works in most cells but in some cells, it keeps displaying (0) even though the formatting is copied to the relevant...

I am during an comparisons on 30 different companines on several products, what I need is the lowest prices without the zeroes or blanks being shown before or...

Hi all, I was hoping for some advice - I've got Index function pulling data and (as expected) in cases where the data-source cell is "", the Index returns...

Hhow do I (left) zero fill a right aligned set of numbers without inserting each one manually?

I am working on a spreadsheet in Excel, however I can not get the zero(0) to display in the cell as a first digit of a number. Example: 0319 is displayed as...

Hi All, I'm creating a spreadsheet that has some time calculations in it. The problem is that I want to hide all zero values. Now, I've already got the...

How do I format cells in a spreadsheet to not show a zero balance as being negative, i.e (0.00)? This does not happen in all of the cells only some?

How can I format a cell to not show the result of a formula as being a negative zero, ie (0.00)? This does not happen with all of the cells only some.

I have this formula that works very well. =IF(ISBLANK(E297),IF(ISBLANK(C297),TEXT((D297-B297)/30.43,"#.0")&" (Plan-Plan)",TEXT((D297-C297)/30.43,"#.0")&"...

I'm creating an IF statement to add up cells dependent on whether a cell is blank or not and I can't seem to get Excel to differentiate between a zero and a...

I need to turn off the zero values for the majority of one sheet I have, but not for all - there are two rows of cells that need to be able to show zeros. Is...