Re: $$Excel-Macros$$ small query

*With formula* http://web.pdx.edu/~wde/Code/Excel_Files/No_VBA_Spellout.php VBA http://www.contextures.com/excelfilesRon.html#RF0001 http://support.microsoft.com/kb/213360 On Mon, Dec 17, 2012 at 1:20 PM, NOORAIN ANSARI wrote: > Dear Delin, > > Please see attached sheet with Excel an

Re: $$Excel-Macros$$ small query

Dear Delin, Please see attached sheet with Excel and VBA solution both. On Mon, Dec 17, 2012 at 12:55 PM, DELIN FRANCIS wrote: > > HI friends... > > A small query in excel is there any way to convert numbers in to words > eg :- > 1202 = One Thousand two hundred and Two > > for more details fi

Re: $$Excel-Macros$$ small query

Hi, Kindly use this function code . "Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True) Dim Crores, Lakhs, Rupees, Paise, Temp Dim DecimalPlace As Long, Count As Long Dim myLakhs, myCrores ReDim Place(9) As String Place(2) = " Thousand ": Place(3) = " Million " Place(4) =

Re: $$Excel-Macros$$ small query about conditional formating

try these first http://www.youtube.com/watch?v=LOaezdoyJDE http://www.techrepublic.com/blog/10things/10-cool-ways-to-use-excels-conditional-formatting-feature/3166 http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html On Wed, Nov 28, 2012 at 10:33 PM, Kenil Gala wrote: > Hi, > Pls help

Re: $$Excel-Macros$$ Small Query

 hi Kenil Gala, find the attached file it will solve your prob regards     Delin.F   From: Kenil Gala To: excel macros Sent: Monday, 26 November 2012 8:48 PM Subject: $$Excel-Macros$$ Small Query Hi, Pls help me solve my small doubt. I have written i

Re: $$Excel-Macros$$ Small Query

Thank you Sir!! --- On Mon, 11/26/12, ashish koul wrote: From: ashish koul Subject: Re: $$Excel-Macros$$ Small Query To: excel-macros@googlegroups.com Date: Monday, November 26, 2012, 4:57 PM  E4=  (7-WEEKDAY(D4,2))+D4 On Mon, Nov 26, 2012 at 10:18 PM, Kenil Gala wrote: Hi, Pls

Re: $$Excel-Macros$$ Small Query

E4= (7-WEEKDAY(D4,2))+D4 On Mon, Nov 26, 2012 at 10:18 PM, Kenil Gala wrote: > Hi, > Pls help me solve my small doubt. > I have written it in the file attached. > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, ac

Re: $$Excel-Macros$$ Small Query

-in-excel-few-tips-tricks/ > ** > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde > *Sent

RE: $$Excel-Macros$$ Small Query

-in-excel-few-tips-tr icks/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 15 September 2012 9:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Small Query

Re: $$Excel-Macros$$ Small Query

gt;> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde >> *Sent:* 14 September 2

Re: $$Excel-Macros$$ Small Query

excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde > *Sent:* 14 September 2012 9:24 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Small Query > > ** ** > > Dear Rajan > > Very

RE: $$Excel-Macros$$ Small Query

cel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 14 September 2012 9:24 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Small Query Dear Rajan Very very thanks for reply. Can u make me understand meaning of (#,##;-#,##;;@ ) this will be helpful for m

Re: $$Excel-Macros$$ Small Query

> * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* 13 September 2012 2:13 > *To:* excel-macros@go

RE: $$Excel-Macros$$ Small Query

Why Don't try Custom format #,##;-#,##;;@ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 13 September 2012 2:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ Small Query

Dear Kuldeep/Noorani/David Very very thanks for kind help Regards Shrinivas On Thu, Sep 13, 2012 at 4:24 PM, David Grugeon wrote: > File/Options/Advanced/Display options for this worksheet > untick "Show a zero in cells that have a zero value" > > This will only work on the active sheet. If y

Re: $$Excel-Macros$$ Small Query

File/Options/Advanced/Display options for this worksheet untick "Show a zero in cells that have a zero value" This will only work on the active sheet. If you want it to apply to the whole workbook select all sheets first. If you want it to apply to new workbooks you create you will need to modify

Re: $$Excel-Macros$$ Small Query

Dear Kuldeep Thanks for reply but where do I use this formula . can u attached file and show it to me. If I enter "0" in A1 then it should not take it should show cell blank Thanks Regards Shrinivas On Thu, Sep 13, 2012 at 12:43 PM, Kuldeep Singh wrote: > > Hi, > > Try This. > > =IFERROR(IF(A1

Re: $$Excel-Macros$$ Small Query

Hi, Try This. =IFERROR(IF(A1,"0",""),"") Regards, Kuldeep Singh On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde wrote: > Dear All > > If i enter 0(zero) in any cell.it should show blank cell. > It should not show the zero. > lease let me know how to do it > Thanks in advance > > -- > Shrini