|
|
Zero values to show blank by
Louise
Hi all
I have formulas on my worksheet and several of the 'answers' are zero, which
is correct, however, I want to format the whole worksheet so rather than...
|
|
9 |
61 |
|
|
Zero values shown as 0 not 0.0 by
Geoff
Does anyone know how to show any value smaller than 0.01
or greater than -0.01 as a single zero, i.e. 0, not 0.0?
Or how to make, for example, 0.0000076500...
|
May 22nd, 2004 06:20 AM
by TJG
|
4 |
105 |
|
|
|
September 22nd, 2005 09:19 AM
by BlueDaze
|
4 |
174 |
|
|
Zero Values in Charts by
Stilla
Is there a way to keep "0%" values ifrom being graphed in a pie chart?
(Besides eliminating the 0's from the source chart, of course).
I have set up some...
|
April 22nd, 2006 07:59 PM
by Stilla
|
3 |
86 |
|
|
Zero Values by
robzrob
Hello
I've got a spreadsheet which I regularly update and email to others
for their use. In every version, it's always set up with the 'Zero
Values' box...
|
March 30th, 2008 12:38 AM
by robzrob
|
2 |
84 |
|
|
Zero Value Ranked by
Bsmile
I need to rank the "% of inc" column but I get an error message (#N/A) on the
ones that have 0%. This is the formula I'm using:...
|
September 21st, 2006 08:20 PM
by Bsmile
|
3 |
57 |
|
|
zero value in cell by
Arthur
I have a table of engineering calculations. The same formula in each cell
operation on variables in the row and column headers. i use the MIN function
to...
|
May 28th, 2010 11:06 PM
by Arthur
|
2 |
690 |
|
|
|
June 18th, 2007 05:39 PM
by Lori
|
4 |
78 |
|
|
|
|
5 |
60 |
|
|
|
|
6 |
101 |
|
|
zero sum by
frustrated
i am using microsoft excel 97 and the resolution to "sum
function returns zero in report output to microsoft excel"
query (Q154396), tells me to change the...
|
|
1 |
69 |
|
|
Zero starts of a number by
Lisa
I export a PO# from system database to excel spreadsheet, but the PO# starts
with zero, for example, 012345, when it exports to excel, the PO# becomes
12345...
|
|
5 |
94 |
|
|
|
|
5 |
136 |
|
|
zero out by
Pieter
I am only a beginner so could you please keep it simple.
I need to build a spreadsheet for weekly reporting.
I need one column for "number installed to...
|
|
3 |
79 |
|
|
Zero or negative rates and XNPV? by
LAHM
Hi,
Does anybody know why XNPV appears not to accept negative rates?
e.g. using the example in the Excel 2003 help: (i.e. amounts = -10000,
2750, 4250, 3250,...
|
March 20th, 2006 04:49 PM
by LAHM
|
4 |
180 |
|
|
Zero on the left !!! by
MAANI
I have cells with numbers like this, 012345678 or 001234567, I formatted all
cells with this function =text(cell,"000000000") so that the zeros are not...
|
October 21st, 2008 08:41 AM
by Max
|
7 |
166 |
|
|
Zero Lines in Spreadsheets (removing) by
CCSWFL
Hi:
I create sets of financials for multiple entities in Excel based on a
standard template. Not all of the accounts are used in each entity. This
causes...
|
|
1 |
61 |
|
|
|
|
4 |
114 |
|
|
|
|
8 |
174 |
|
|
zero in cell is counting as one... by
Frustrated Word User
Hello smart people.
I have a workbook to track injuries in the workplace. A cell is set up to calculate the number of injuries from a given year. Here's...
|
November 26th, 2008 09:26 PM
by T. Valko
|
2 |
379 |