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...

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...

I'm having a problem here... recently upgraded to a new version of excel and I've been looking in all the options can't seem to find a solution. It seems...

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...

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...

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:...

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...

Hi I am using a 3D formula =SUM(COUNTIF(INDIRECT("'"&{"Apr 07","May 07","Jun 07"} &"'!F27:F48"),({"18","=20"})*{-1,1})) to count ages between certain...

I am attempting to build a running daily score average report based on several categories that either have a numeric or N/A value. How do I omit the N/A...

How do you stop Excel from suppressing the leading zeros in a cell used for a barcode that is created using a cell that has them?

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...

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...

I need to bring numeric values forward from ten separate spreadsheets (survey results) to a "helper spreadsheet" in order to calculate the mode of these values...

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...

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,...

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...

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...

I have a cell on one sheet in a workbook as =(PL!A27) which is the sheet and the cell being referenced. I want cell AF1, sheet BOL to automatically fill in...

When I enter a formula to link a cell to another cell, the cell that is copied from the other cell has a ZERO when the linked cell is blank. What is the...

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...