Re: $$Excel-Macros$$ Fill empty cells with zero

r > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Abhishek Jain > Sent: Friday, August 26, 2011 3:38 PM > To: excel-macros@googlegroups.com; ushadhvin...@gmail.com > Subject: Re: $$Excel-Macros$$ Fill empty cells with zero > > Enter the numb

Re: $$Excel-Macros$$ Fill empty cells with zero

Thanks. With regards, Usha On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain wrote: > We have some blank cells in excel (2007), which we want to fill with zero. > what is the formula for the same? > > With regards, > Usha > > -- > > -

Re: $$Excel-Macros$$ Fill empty cells with zero

hey Usha, if blank cell come thru by formula then use if condition other wise use find and replace function On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain wrote: > We have some blank cells in excel (2007), which we want to fill with zero. > what is the formula for the same? > > With regards, > Us

Re: $$Excel-Macros$$ Fill empty cells with zero

Try it through Coding Sub replace_by_0() Dim s As Range For Each s In Selection If s.Value = "" Then s.Value = "0" End If Next s End Sub -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 26, 2011 at 4:21 PM, Venkat CV w

Re: $$Excel-Macros$$ Fill empty cells with zero

Try Find and replace Option. *Best Regards,* *Venkat * *Chennai* On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain wrote: > We have some blank cells in excel (2007), which we want to fill with zero. > what is the formula for the same? > > With regards, > Usha > > -- > > -

RE: $$Excel-Macros$$ Fill empty cells with zero

...@gmail.com Subject: Re: $$Excel-Macros$$ Fill empty cells with zero Enter the number 1 in an unused cell and copy that cell to the clipboard. Highlight the range of cells in which you want blanks replaced by zeros (Go to > Blank Cells). Choose Edit | Paste Special from the menu. In the Operat

Re: $$Excel-Macros$$ Fill empty cells with zero

Enter the number 1 in an unused cell and copy that cell to the clipboard. Highlight the range of cells in which you want blanks replaced by zeros (Go to > Blank Cells). Choose *Edit *| *Paste Special *from the menu. In the * Operation *section of the resulting dialog box, select the *Multiply *opti