|
|
zip code entry by
mphope
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...
|
|
1 |
92 |
|
|
zip code entry by
Margo
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...
|
April 5th, 2005 04:07 AM
by Margo
|
0 |
74 |
|
|
zip code by
chuck
frank -- your message was unavailable....do you have any
answer to the zip code question
|
|
2 |
100 |
|
|
Zeros problem in LOOKUP? by
Danopnu
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...
|
September 21st, 2006 09:34 AM
by Jaleel
|
6 |
61 |
|
|
Zeros in Linking by
BrianK
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...
|
|
3 |
101 |
|
|
Zeros in cells by
mhogan
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.
...
|
|
2 |
74 |
|
|
|
October 27th, 2005 01:22 PM
by Ian
|
3 |
127 |
|
|
Zeros displaying in cell when using = sign by
watermt
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...
|
|
2 |
846 |
|
|
zeros by
Flipper
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...
|
|
5 |
341 |
|
|
zeros by
heritage
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...
|
|
3 |
133 |
|
|
zeroes by
larry
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...
|
|
4 |
116 |
|
|
|
|
2 |
97 |
|
|
Zero-Fill by
TDL
Hhow do I (left) zero fill a right aligned set of numbers without inserting
each one manually?
|
|
9 |
64 |
|
|
|
December 11th, 2007 07:34 AM
by OssieMac
|
3 |
86 |
|
|
Zero's, Rounding, and Hiding by
Ashley
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...
|
|
2 |
52 |
|
|
Zero's show as being negative numbers by
Jose
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?
|
|
2 |
53 |
|
|
|
March 19th, 2007 08:32 PM
by bj
|
1 |
77 |
|
|
Zero's by
PAL
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")&"...
|
|
3 |
85 |
|
|
zero vs. null value by
Cheryl Schuberth
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...
|
July 19th, 2004 03:51 PM
by JulieD
|
1 |
132 |
|
|
Zero values: some on and some off by
Phrank
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...
|
|
1 |
49 |