zeroes

  1. edge37

    Help modifying a code for filling blanks in selected range with zeroes

    Hi, I am using this code to fill a selected range of cells with zeros if they are blank, the thing is that this code fills the blank cells one by one, and could take some time to finish. Can you help me please modify this code so it fills blank cells from a selected range all at once...
  2. C

    Average Formula -- Ignore cells with "0%"

    Hello. This may not be possible but I'll ask anyway as I've not been able to work it out myself... :( I have a table which collates scores and calculates the total score as percentage. These percentage cells are spread out over one row, but over multiple separated columns because there are...
  3. H

    Delete Rows where Col B & C have zeroes

    I have tried to write code to delete rows containing zeroes in Col B & C, but only the first row containing zeroes are deleted...
  4. H

    Macro to clear Zeroes in Col A to C

    I have written code to clear zeroes in Col A to C I get a type mismatch when running the code and the following code is highlighted If .Cells(i, 1).Resize(, 2) = 0 Then See full code below Sub clear_Zero_Values() With Sheets(1) Dim lr As Long Dim i As Long lr =...
  5. H

    Macro to remove leading zeroes

    I need code to remove leading zeroes in Col N from row 2 onwards on Sheet2 See sample data below. The data can have any number of leading zeroes 0025795 0957825 00000758 Your assistance is most appreciated in resolving this
  6. B

    Formatting numbers for a bank upload

    I have a file that displays dollar amounts as such: 30 86.25 150 170.84 So it's really $30.00, $86.25, $150.00, $170.84 I have to convert those numbers so that they become as follows: 3000 8625 15000 17084 So it's not just a matter of adding a set number of following zeroes, because...
  7. D

    Adding Zeroes

    Hi I have an issue whereby every time I want to enter a number I have to enter 2 zeroes after it so it shows up correctly. An example is if I just enter the number 5, it shows in the cell as 0.05. If I enter 500 then it shows up in the cell as 5. This is extremely frustrating and I cannot solve...
  8. JenniferMurphy

    Easy way to display non-zero decimal places?

    I have a UDF that calculates the odds for various events. One of the formats it can use for the result is the fractional odds (5:1, 3/4, etc.). I would like to display these in the most compact form possible. That is, no trailing zeroes. Here's some sample data the results I want: <tbody>...
  9. N

    Dynamic Range

    I am running a dynamic range over the last 45 days of data in a worksheet, however some days the number entered is a Zero, for example on a Sunday. How can I use the formula below, but also have the formula remove the zeroes from the calculated average? It can consider a zero one of the 45...
  10. 6

    countif doesn't return the correct result when using "<>"

    Take this table: <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> code 058 03102 0504 </tbody> where the "numbers" are stored as text to preserve the leading zero(es). The formula =COUNTIF(A2:A4;"=058") returns 1. Why does the formula...
  11. I

    remove zeroes

    Dear all i want to remove the starting zeroes source 000046 000001 000123 005426 012345 876541 output must be 46 1 123 5426 12345 876451 could you please provide the formula?
  12. J

    Graph is graphing #N/A formula results as 0's, distorting the trend and look of my graph

    It's weird. In one tab of my workbook, any formulas resulting in 0's I have programmed to actually return a #N/A, so that when graphed, the graph looks cleaner, and the trendline is true. But in another new tab I'm working in, the #N/A results show up as zeroes on the graphs. Any reason you know...
  13. R

    Remove Leading Zeroes

    Hello. I use Excel 2010. I have a column of cells where some values begin with leading zeroes while other values begin with a letter. Can anyone tell me how to remove only the leading zeroes? Below is an example set of records with BEFORE and then AFTER(what I need for them to become): BEFORE...
  14. K

    Earliest date in a row that may contain 1/0/1900 (zero)

    I've read the other posts about finding the earliest date in a row. However, in my case, I have 20 columns of dates in the row. The first column does not necessarily contain the earliest date. Once there is no legitimate date for a column, the remaining columns are filled with 1/0/1900...
  15. M

    Plotting of Empty Cells (No values/No Formula)

    So I created a calculations formula (data oriented in columns) and drag filled formula across multiple columns. Then I Selected row with formula results, copied and paste special (values and formatting only) into row below. When I Scatterplot (no connecting line) the pasted values all empty...
  16. T

    Help with skipping zeroes and blanks

    Hi. I've researched this question and saw how you can find the min with simpler ranges, but my equation doesn't work with what I've found so far. Can anyone help me? I want to skip the zeroes and blanks. Thanks...
  17. P

    How can I make it so that a cell is formatted to the point where whatever number I type in stays the exact way that I typed it

    Pretty much I just need to be able to have zeroes in front of numbers without converting the number to text. And also note that the numbers that I am going to be pasting in that cell need to be able to be any size and still be able to keep the zeroes in front of them. popcornrulez
  18. L

    Average while ignoring zeros and errors

    Hello! I'm trying to return the average, min and max values of a range that will have errors, be blank or have zeros. I have already found an array formula that works getting rid of the errors but the zeros are now a problem. {=AVERAGE(IF(NOT(ISERROR(D27:G27)),D27:G27))} I was thinking that...
  19. T

    Charts go to zero on blank cells - only when linked to other workbook that is closed

    Excel 2010 I have a number of line charts that are linked to data ranges in other workbooks. The ranges include a number of blank cells (future data to be dragged down weekly). These cells are actually blank, not formulas conditionally returning a blank. These blanks are displaying as zeroes on...
  20. J

    Remove leading zeroes

    I have a column of numbers: 000,093,425 000,391,156.42 000,124,231,113.02 000,001,201.01 I want to remove all leading zeroes and convert the data to: 93,425 391,156.42 124,231,113.02 1,201.01 Is there a simple way to do this?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top