How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet?

Hi, I have to sum the numbers in column B *column C in column D. The problem is that the data in column B are not always a numbers and some times are...

I have the following formula in place: =IF(SUM(I14:N14)1,SUM(I14:N14),"") The problem I have is when zeros are legitimately entered in the reference fields...

In F8, I have a formula that results in the value "0" (zero). I have the cell formatted as a number. In H8, I have the following...

I have a problem to add numbers with cells that has error. Any advice what can be done? Thanks A B C a 5 5 5 b 1 1 0 a/b 5 5 #DIV/0! SUM A+B+C...

I have created a Custom Format to Zero Fill a Numeric Cell but can not get the cells to display the Custom Format with out Editing (F2) each field and pressing...

I am trying to evaluate a cell and return zero if zero is put into the cell, blank if the cell is left blank and evaluate a formula if a number other then...

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

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

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

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

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

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

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